How to find the source code of a seeded HRMS formula function

To  look at the source code a formula function i.e. if you want to determine
the logic used to return the value concerned you can do the following

1. Establish the defintion name held in the table FF_FUNCTIONS

For example if you are interested in the function called
CALCULATE_CONTINUOUS_SERVICE

SELECT DEFINITION FROM FF_FUNCTIONS WHERE NAME = ‘CALCULATE_CONTINUOUS_SERVICE’

This will return the package.procedure

In this case it returns
pqp_service_history_calc_pkg.calcualate_continuous_service

2.Establish the file name held on the service for this package

SELECT TEXT FROM USER_SOURCE WHERE NAME = ‘PQP_SERVICE_HISTORY_CALC_PKG’
AND TEXT LIKE ‘%$Header%’

This will return the file name

In this case this is

pqshpcal.pkb

3.Access the package body code from the server and identify the procedure
concerned

In this case you can search code until locate function

calcualate_continuous_service