DBA Data[Home] [Help]

APPS.PAY_SE_EFT dependencies on FND_DATE

Line 15: ,fnd_date.canonical_to_date(pay_se_eft.get_parameter(ppa.payroll_action_id,

11: SELECT
12: 'START=P'
13: ,1
14: ,'PROCESS_DATE=P'
15: ,fnd_date.canonical_to_date(pay_se_eft.get_parameter(ppa.payroll_action_id,
16: 'PROCESS_DATE'))
17: from pay_payroll_actions ppa
18: where ppa.payroll_action_id =pay_magtape_generic.get_parameter_value
19: ('PAYROLL_ACTION_ID');

Line 63: ,fnd_date.canonical_to_date(pay_se_eft.get_parameter(ppa.payroll_action_id,'START_DATE'))||' - '

59: ,RPAD(NVL(substr(hoi4.org_information3,1,10),' '),10,' ')
60: ,'PAYROLL=P'
61: ,pap.payroll_Name
62: ,'PAYMENT_PERIOD=P'
63: ,fnd_date.canonical_to_date(pay_se_eft.get_parameter(ppa.payroll_action_id,'START_DATE'))||' - '
64: ||fnd_date.canonical_to_date(pay_se_eft.get_parameter(ppa.payroll_action_id,'PROCESS_DATE'))
65: ,'BANKGIRO_NO=P'
66: ,pay_se_eft.get_parameter(ppa.payroll_action_id,'BANKGIRO_NO')
67: from

Line 64: ||fnd_date.canonical_to_date(pay_se_eft.get_parameter(ppa.payroll_action_id,'PROCESS_DATE'))

60: ,'PAYROLL=P'
61: ,pap.payroll_Name
62: ,'PAYMENT_PERIOD=P'
63: ,fnd_date.canonical_to_date(pay_se_eft.get_parameter(ppa.payroll_action_id,'START_DATE'))||' - '
64: ||fnd_date.canonical_to_date(pay_se_eft.get_parameter(ppa.payroll_action_id,'PROCESS_DATE'))
65: ,'BANKGIRO_NO=P'
66: ,pay_se_eft.get_parameter(ppa.payroll_action_id,'BANKGIRO_NO')
67: from
68: pay_payroll_actions ppa,