DBA Data[Home] [Help]

APPS.PAY_NL_PAYFILE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 66: FROM pay_assignment_actions pas

62: WHERE ppa.payroll_action_id =
63: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
64: AND EXISTS (
65: SELECT 1
66: FROM pay_assignment_actions pas
67: ,pay_pre_payments ppp
68: WHERE pas.payroll_action_id = ppa.payroll_action_id
69: AND ppp.pre_payment_id = pas.pre_payment_id
70: AND ppp.value > 0 );

Line 108: ,pay_assignment_actions paa

104: ,min(ppp.pre_payment_id)
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 =