DBA Data[Home] [Help]

APPS.PAY_KW_GENERAL dependencies on PAY_ASSIGNMENT_ACTIONS

Line 275: ,pay_assignment_actions paa

271: SELECT COUNT(*)
272: FROM per_assignments_f paf
273: ,per_people_f pef
274: ,pay_pre_payments ppp
275: ,pay_assignment_actions paa
276: ,pay_payroll_actions ppa
277: WHERE paa.payroll_action_id =
278: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
279: AND paa.pre_payment_id = ppp.pre_payment_id

Line 302: ,pay_assignment_actions paa

298: SELECT SUM(ppp.value)
299: FROM per_assignments_f paf
300: ,per_people_f pef
301: ,pay_pre_payments ppp
302: ,pay_assignment_actions paa
303: ,pay_payroll_actions ppa
304: WHERE paa.payroll_action_id =
305: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
306: AND paa.pre_payment_id = ppp.pre_payment_id