162: ,ppf.payroll_id
163: FROM per_time_periods ptp
164: ,pay_action_information pai_emp
165: ,pay_assignment_actions paa1
166: ,pay_action_interlocks lck
167: ,pay_payroll_actions ppa1
168: ,pay_all_payrolls_f ppf
169: WHERE ptp.payroll_id = l_payroll_id
170: AND ptp.time_period_id = pai_emp.action_information16
208: ,ppf.payroll_id
209: FROM per_time_periods ptp
210: ,pay_action_information pai_emp
211: ,pay_assignment_actions paa1
212: ,pay_action_interlocks lck
213: ,pay_payroll_actions ppa1
214: ,pay_all_payrolls_f ppf
215: WHERE ptp.time_period_id = pai_emp.action_information16
216: AND pai_emp.action_context_type = 'AAP'
274: ,ppf.payroll_id
275: FROM per_time_periods ptp
276: ,pay_action_information pai_emp
277: ,pay_assignment_actions paa1
278: ,pay_action_interlocks lck
279: ,pay_payroll_actions ppa1
280: ,pay_all_payrolls_f ppf
281: WHERE ptp.time_period_id = pai_emp.action_information16
282: AND pai_emp.action_context_type = 'AAP'
319: ,ppf.payroll_id
320: FROM per_time_periods ptp
321: ,pay_action_information pai_emp
322: ,pay_assignment_actions paa1
323: ,pay_action_interlocks lck
324: ,pay_payroll_actions ppa1
325: ,pay_all_payrolls_f ppf
326: WHERE ptp.time_period_id = pai_emp.action_information16
327: AND pai_emp.action_context_type = 'AAP'
347: SELECT distinct ppf.payroll_id
348: FROM per_time_periods ptp
349: ,pay_action_information pai_emp
350: ,pay_assignment_actions paa1
351: ,pay_action_interlocks lck
352: ,pay_payroll_actions ppa1
353: ,pay_all_payrolls_f ppf
354: WHERE ptp.time_period_id = pai_emp.action_information16
355: AND pai_emp.action_context_type = 'AAP'
411: SELECT distinct ppf.payroll_id
412: FROM per_time_periods ptp
413: ,pay_action_information pai_emp
414: ,pay_assignment_actions paa1
415: ,pay_action_interlocks lck
416: ,pay_payroll_actions ppa1
417: ,pay_all_payrolls_f ppf
418: WHERE ptp.time_period_id = pai_emp.action_information16
419: AND pai_emp.action_context_type = 'AAP'
459: FROM per_time_periods ptp
460: ,pay_action_information pai_emp
461: ,pay_action_information pai_emp1
462: ,pay_assignment_actions paa1
463: ,pay_action_interlocks lck
464: ,pay_payroll_actions ppa1
465: ,pay_all_payrolls_f ppf
466: WHERE ptp.payroll_id = l_payroll_id
467: AND ptp.time_period_id = pai_emp.action_information16
550: ,pai.action_information4 earn_element
551: ,pet.result_value earn_value
552: ,pai.action_information7
553: FROM
554: pay_action_interlocks lck,
555: pay_assignment_actions paa1,
556: pay_assignment_actions paa2,
557: pay_payroll_actions ppa,
558: pay_action_information pai,
596: ,pai.action_information4 ded_element
597: ,pet.result_value ded_value
598: ,pai.action_information7
599: FROM
600: pay_action_interlocks lck,
601: pay_assignment_actions paa1,
602: pay_assignment_actions paa2,
603: pay_payroll_actions ppa,
604: pay_action_information pai,
631: ,pen.value pay_amount
632: ,pen.action_context_id
633: ,pay_assignment_actions_pkg.get_payment_status(paa.assignment_action_id,ppp.pre_payment_id) status
634: FROM pay_emp_net_dist_action_info_v pen
635: ,pay_action_interlocks pai
636: ,pay_assignment_actions paa
637: ,pay_payroll_actions ppa
638: ,pay_pre_payments ppp
639: WHERE pen.action_context_id = l_assact_id
662: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
663: FROM per_time_periods ptp
664: ,pay_action_information pai_emp
665: ,pay_assignment_actions paa1
666: ,pay_action_interlocks lck
667: ,pay_payroll_actions ppa1
668: WHERE ptp.payroll_id = l_payroll_id
669: AND ptp.time_period_id = pai_emp.action_information16
670: AND pai_emp.action_context_type = 'AAP'
693: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
694: FROM per_time_periods ptp
695: ,pay_action_information pai_emp
696: ,pay_assignment_actions paa1
697: ,pay_action_interlocks lck
698: ,pay_payroll_actions ppa1
699: WHERE ptp.payroll_id = l_payroll_id
700: AND ptp.time_period_id = pai_emp.action_information16
701: AND pai_emp.action_context_type = 'AAP'
723: SELECT sum(pay_v.numeric_value)
724: FROM pay_assignment_actions paa
725: ,per_time_periods ptp
726: ,pay_assignment_actions paa1
727: ,pay_action_interlocks lck
728: ,pay_payroll_actions ppa1
729: ,pay_action_information pai_ele
730: ,pay_action_information pai_emp
731: ,pay_emea_paymnts_action_info_v pay_v
757: select pai_emp.action_context_id arch_assact
758: from per_time_periods ptp
759: ,pay_action_information pai_emp
760: ,pay_assignment_actions paa1
761: ,pay_action_interlocks lck
762: ,pay_payroll_actions ppa1
763: where ptp.payroll_id = l_payroll_id
764: and ptp.time_period_id = pai_emp.action_information16
765: and pai_emp.action_context_type = 'AAP'
808: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
809: FROM per_time_periods ptp
810: ,pay_action_information pai_emp
811: ,pay_assignment_actions paa1
812: ,pay_action_interlocks lck
813: ,pay_payroll_actions ppa1
814: WHERE ptp.payroll_id = l_payroll_id
815: AND ptp.time_period_id = pai_emp.action_information16
816: AND pai_emp.action_context_type = 'AAP'
838: SELECT sum(pay_v.numeric_value)
839: FROM pay_assignment_actions paa
840: ,per_time_periods ptp
841: ,pay_assignment_actions paa1
842: ,pay_action_interlocks lck
843: ,pay_payroll_actions ppa1
844: ,pay_action_information pai_ele
845: ,pay_action_information pai_emp
846: ,pay_emea_paymnts_action_info_v pay_v
872: select pai_emp.action_context_id arch_assact
873: from per_time_periods ptp
874: ,pay_action_information pai_emp
875: ,pay_assignment_actions paa1
876: ,pay_action_interlocks lck
877: ,pay_payroll_actions ppa1
878: where ptp.payroll_id = l_payroll_id
879: and ptp.time_period_id = pai_emp.action_information16
880: and pai_emp.action_context_type = 'AAP'