DBA Data[Home] [Help]

APPS.PAY_FI_EFT dependencies on PAY_PAYROLL_ACTIONS

Line 20: FROM pay_payroll_actions ppa

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')
23: AND EXISTS (
24: SELECT 1

Line 55: pay_payroll_actions ppa

51: ,'ASSIGNMENT_ACTION_ID=C', paa.assignment_action_id
52: ,'ORGANIZATION_ID=C' , paf.organization_id
53: ,'TAX_UNIT_ID=C' , paa.tax_unit_id
54: from
55: pay_payroll_actions ppa
56: ,pay_assignment_actions paa
57: ,per_all_assignments_f paf
58: ,pay_pre_payments ppp
59: ,pay_personal_payment_methods_f pppm