[Home] [Help]
161: ,ppf.payroll_id
162: FROM per_time_periods ptp
163: ,pay_action_information pai_emp
164: ,pay_assignment_actions paa1
165: ,pay_action_interlocks lck
166: ,pay_payroll_actions ppa1
167: ,pay_all_payrolls_f ppf
168: WHERE ptp.payroll_id = l_payroll_id
169: AND ptp.time_period_id = pai_emp.action_information16
184: ,ppf.payroll_id
185: FROM per_time_periods ptp
186: ,pay_action_information pai_emp
187: ,pay_assignment_actions paa1
188: ,pay_action_interlocks lck
189: ,pay_payroll_actions ppa1
190: ,pay_all_payrolls_f ppf
191: WHERE ptp.time_period_id = pai_emp.action_information16
192: AND pai_emp.action_context_type = 'AAP'
217: ,ppf.payroll_id
218: FROM per_time_periods ptp
219: ,pay_action_information pai_emp
220: ,pay_assignment_actions paa1
221: ,pay_action_interlocks lck
222: ,pay_payroll_actions ppa1
223: ,pay_all_payrolls_f ppf
224: WHERE ptp.time_period_id = pai_emp.action_information16
225: AND pai_emp.action_context_type = 'AAP'
239: ,ppf.payroll_id
240: FROM per_time_periods ptp
241: ,pay_action_information pai_emp
242: ,pay_assignment_actions paa1
243: ,pay_action_interlocks lck
244: ,pay_payroll_actions ppa1
245: ,pay_all_payrolls_f ppf
246: WHERE ptp.time_period_id = pai_emp.action_information16
247: AND pai_emp.action_context_type = 'AAP'
261: SELECT distinct ppf.payroll_id
262: FROM per_time_periods ptp
263: ,pay_action_information pai_emp
264: ,pay_assignment_actions paa1
265: ,pay_action_interlocks lck
266: ,pay_payroll_actions ppa1
267: ,pay_all_payrolls_f ppf
268: WHERE ptp.time_period_id = pai_emp.action_information16
269: AND pai_emp.action_context_type = 'AAP'
294: SELECT distinct ppf.payroll_id
295: FROM per_time_periods ptp
296: ,pay_action_information pai_emp
297: ,pay_assignment_actions paa1
298: ,pay_action_interlocks lck
299: ,pay_payroll_actions ppa1
300: ,pay_all_payrolls_f ppf
301: WHERE ptp.time_period_id = pai_emp.action_information16
302: AND pai_emp.action_context_type = 'AAP'
341: FROM per_time_periods ptp
342: ,pay_action_information pai_emp
343: ,pay_action_information pai_emp1
344: ,pay_assignment_actions paa1
345: ,pay_action_interlocks lck
346: ,pay_payroll_actions ppa1
347: ,pay_all_payrolls_f ppf
348: WHERE ptp.payroll_id = l_payroll_id
349: AND ptp.time_period_id = pai_emp.action_information16
389: ,pai.action_information4 earn_element
390: ,pet.result_value earn_value
391: ,pai.action_information7
392: FROM
393: pay_action_interlocks lck,
394: pay_assignment_actions paa1,
395: pay_assignment_actions paa2,
396: pay_payroll_actions ppa,
397: pay_action_information pai,
435: ,pai.action_information4 ded_element
436: ,pet.result_value ded_value
437: ,pai.action_information7
438: FROM
439: pay_action_interlocks lck,
440: pay_assignment_actions paa1,
441: pay_assignment_actions paa2,
442: pay_payroll_actions ppa,
443: pay_action_information pai,
470: ,pen.value pay_amount
471: ,pen.action_context_id
472: ,pay_assignment_actions_pkg.get_payment_status(paa.assignment_action_id,ppp.pre_payment_id) status
473: FROM pay_emp_net_dist_action_info_v pen
474: ,pay_action_interlocks pai
475: ,pay_assignment_actions paa
476: ,pay_payroll_actions ppa
477: ,pay_pre_payments ppp
478: WHERE pen.action_context_id = l_assact_id
501: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
502: FROM per_time_periods ptp
503: ,pay_action_information pai_emp
504: ,pay_assignment_actions paa1
505: ,pay_action_interlocks lck
506: ,pay_payroll_actions ppa1
507: WHERE ptp.payroll_id = l_payroll_id
508: AND ptp.time_period_id = pai_emp.action_information16
509: AND pai_emp.action_context_type = 'AAP'
532: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
533: FROM per_time_periods ptp
534: ,pay_action_information pai_emp
535: ,pay_assignment_actions paa1
536: ,pay_action_interlocks lck
537: ,pay_payroll_actions ppa1
538: WHERE ptp.payroll_id = l_payroll_id
539: AND ptp.time_period_id = pai_emp.action_information16
540: AND pai_emp.action_context_type = 'AAP'
562: SELECT sum(pay_v.numeric_value)
563: FROM pay_assignment_actions paa
564: ,per_time_periods ptp
565: ,pay_assignment_actions paa1
566: ,pay_action_interlocks lck
567: ,pay_payroll_actions ppa1
568: ,pay_action_information pai_ele
569: ,pay_action_information pai_emp
570: ,pay_emea_paymnts_action_info_v pay_v
596: select pai_emp.action_context_id arch_assact
597: from per_time_periods ptp
598: ,pay_action_information pai_emp
599: ,pay_assignment_actions paa1
600: ,pay_action_interlocks lck
601: ,pay_payroll_actions ppa1
602: where ptp.payroll_id = l_payroll_id
603: and ptp.time_period_id = pai_emp.action_information16
604: and pai_emp.action_context_type = 'AAP'
647: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
648: FROM per_time_periods ptp
649: ,pay_action_information pai_emp
650: ,pay_assignment_actions paa1
651: ,pay_action_interlocks lck
652: ,pay_payroll_actions ppa1
653: WHERE ptp.payroll_id = l_payroll_id
654: AND ptp.time_period_id = pai_emp.action_information16
655: AND pai_emp.action_context_type = 'AAP'
677: SELECT sum(pay_v.numeric_value)
678: FROM pay_assignment_actions paa
679: ,per_time_periods ptp
680: ,pay_assignment_actions paa1
681: ,pay_action_interlocks lck
682: ,pay_payroll_actions ppa1
683: ,pay_action_information pai_ele
684: ,pay_action_information pai_emp
685: ,pay_emea_paymnts_action_info_v pay_v
711: select pai_emp.action_context_id arch_assact
712: from per_time_periods ptp
713: ,pay_action_information pai_emp
714: ,pay_assignment_actions paa1
715: ,pay_action_interlocks lck
716: ,pay_payroll_actions ppa1
717: where ptp.payroll_id = l_payroll_id
718: and ptp.time_period_id = pai_emp.action_information16
719: and pai_emp.action_context_type = 'AAP'