DBA Data[Home] [Help]

APPS.PAY_SA_GENERAL dependencies on PAY_ASSIGNMENT_ACTIONS

Line 202: ,pay_assignment_actions paa

198: SUM(ppp.value)
199: FROM per_assignments_f paf
200: ,per_people_f pef
201: ,pay_pre_payments ppp
202: ,pay_assignment_actions paa
203: ,pay_payroll_actions ppa
204: WHERE paa.payroll_action_id =
205: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
206: AND paa.pre_payment_id = ppp.pre_payment_id

Line 230: ,pay_assignment_actions paa

226: COUNT(*)
227: FROM per_assignments_f paf
228: ,per_people_f pef
229: ,pay_pre_payments ppp
230: ,pay_assignment_actions paa
231: ,pay_payroll_actions ppa
232: WHERE paa.payroll_action_id =
233: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
234: AND paa.pre_payment_id = ppp.pre_payment_id

Line 274: FROM pay_assignment_actions paa

270:
271: CURSOR csr_get_assact_id IS
272: SELECT paa.assignment_action_id
273: ,ppa.date_earned
274: FROM pay_assignment_actions paa
275: ,pay_payroll_actions ppa
276: ,pay_run_results prr
277: ,pay_element_types_f pet
278: WHERE paa.assignment_id = p_assignment_id