APPS.PAY_FI_EFT dependencies on FND_DATE

Line 18: to_char(fnd_date.canonical_to_date(pay_fi_eft.get_parameter

14: ********************************************************/
15:
16: CURSOR CSR_FI_EFT_HEADER IS
17: select 'PROCESS_DATE=P',
18: to_char(fnd_date.canonical_to_date(pay_fi_eft.get_parameter
19: (ppa.legislative_parameters,'PROCESS_DATE')),'YYYYMMDD')
20: FROM pay_payroll_actions ppa
21: WHERE ppa.payroll_action_id =
22: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 36: ,'PAY_DATE=P',to_char(fnd_date.canonical_to_date(pay_fi_eft.get_parameter

32: * Cursor to fetch Body record information *
33: ********************************************************/
34: CURSOR CSR_FI_EFT_BODY IS
35: SELECT /*+ INDEX( hsck , HR_SOFT_CODING_KEYFLEX_PK) */ 'PAYER_CODE=P',hoi2.org_information1
36: ,'PAY_DATE=P',to_char(fnd_date.canonical_to_date(pay_fi_eft.get_parameter
37: (ppa.legislative_parameters,'PROCESS_DATE')),'YYYYMMDD')
38: ,'PAYER_NAME=P',substr(o1.name,1,16)
39: ,'PAYER_INFO=P',lpad(nvl(pay_fi_eft.get_parameter(ppa.legislative_parameters,'PAYER_INFO'),' '),10,' ')
40: ,'PAYEE_CODE=P',pef.national_identifier