DBA Data[Home] [Help]

APPS.PAY_AE_GENERAL dependencies on PAY_ASSIGNMENT_ACTIONS

Line 289: ,pay_assignment_actions paa

285: SELECT COUNT(*)
286: FROM per_assignments_f paf
287: ,per_people_f pef
288: ,pay_pre_payments ppp
289: ,pay_assignment_actions paa
290: ,pay_payroll_actions ppa
291: WHERE paa.payroll_action_id =
292: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
293: AND paa.pre_payment_id = ppp.pre_payment_id

Line 316: ,pay_assignment_actions paa

312: SELECT SUM(ppp.value)
313: FROM per_assignments_f paf
314: ,per_people_f pef
315: ,pay_pre_payments ppp
316: ,pay_assignment_actions paa
317: ,pay_payroll_actions ppa
318: WHERE paa.payroll_action_id =
319: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
320: AND paa.pre_payment_id = ppp.pre_payment_id

Line 344: ,pay_assignment_actions paa

340: SELECT SUM(ppp.value)
341: FROM per_assignments_f paf
342: ,per_people_f pef
343: ,pay_pre_payments ppp
344: ,pay_assignment_actions paa
345: ,pay_payroll_actions ppa
346: WHERE paa.payroll_action_id =
347: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
348: AND paa.pre_payment_id = ppp.pre_payment_id

Line 372: ,pay_assignment_actions paa

368: SELECT SUM(ppp.value)
369: FROM per_assignments_f paf
370: ,per_people_f pef
371: ,pay_pre_payments ppp
372: ,pay_assignment_actions paa
373: ,pay_payroll_actions ppa
374: WHERE paa.payroll_action_id =
375: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
376: AND paa.pre_payment_id = ppp.pre_payment_id