[Home] [Help]
326: ,pay_pre_payments ppp
327: ,pay_assignment_actions paa
328: ,pay_payroll_actions ppa
329: WHERE paa.payroll_action_id =
330: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
331: AND paa.pre_payment_id = ppp.pre_payment_id
332: AND paa.payroll_action_id = ppa.payroll_action_id
333: AND paa.assignment_id = paf.assignment_id
334: AND paf.person_id = pef.person_id
353: ,pay_pre_payments ppp
354: ,pay_assignment_actions paa
355: ,pay_payroll_actions ppa
356: WHERE paa.payroll_action_id =
357: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
358: AND paa.pre_payment_id = ppp.pre_payment_id
359: AND paa.payroll_action_id = ppa.payroll_action_id
360: AND paa.assignment_id = paf.assignment_id
361: AND paf.person_id = pef.person_id
381: ,pay_pre_payments ppp
382: ,pay_assignment_actions paa
383: ,pay_payroll_actions ppa
384: WHERE paa.payroll_action_id =
385: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
386: AND paa.pre_payment_id = ppp.pre_payment_id
387: AND paa.payroll_action_id = ppa.payroll_action_id
388: AND paa.assignment_id = paf.assignment_id
389: AND paf.person_id = pef.person_id
409: ,pay_pre_payments ppp
410: ,pay_assignment_actions paa
411: ,pay_payroll_actions ppa
412: WHERE paa.payroll_action_id =
413: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
414: AND paa.pre_payment_id = ppp.pre_payment_id
415: AND paa.payroll_action_id = ppa.payroll_action_id
416: AND paa.assignment_id = paf.assignment_id
417: AND paf.person_id = pef.person_id