DBA Data[Home] [Help]

APPS.PAY_NL_PAYFILE dependencies on PAY_PAYROLL_ACTIONS

Line 61: FROM pay_payroll_actions ppa

57: ,'DATE_EARNED=C'
58: ,to_char(ppa.effective_date, 'YYYY/MM/DD HH24:MI:SS')
59: ,'ORG_PAY_METHOD_ID=C'
60: ,ppa.org_payment_method_id
61: FROM pay_payroll_actions ppa
62: WHERE ppa.payroll_action_id =
63: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
64: AND EXISTS (
65: SELECT 1

Line 109: ,pay_payroll_actions ppa

105: FROM per_assignments_f paf
106: ,per_people_f pef
107: ,pay_pre_payments ppp
108: ,pay_assignment_actions paa
109: ,pay_payroll_actions ppa
110: ,pay_personal_payment_methods_f ppmf
111: ,pay_external_accounts pea
112: WHERE paa.payroll_action_id =
113: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')