eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KW_PAYROLL_REGISTER dependencies on PAY_PAYROLL_ACTIONS

Line 167: ,pay_payroll_actions ppa1

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
171: AND pai_emp.action_context_type = 'AAP'

Line 189: ,pay_payroll_actions ppa1

185: ,ppf.payroll_id
186: FROM per_time_periods ptp
187: ,pay_action_information pai_emp
188: ,pay_assignment_actions paa1
189: ,pay_payroll_actions ppa1
190: ,pay_all_payrolls_f ppf
191: WHERE ptp.payroll_id = l_payroll_id
192: AND ptp.time_period_id = pai_emp.action_information16
193: AND pai_emp.action_context_type = 'AAP'

Line 213: ,pay_payroll_actions ppa1

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'
217: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 245: ,pay_payroll_actions ppa1

241: ,ppf.payroll_id
242: FROM per_time_periods ptp
243: ,pay_action_information pai_emp
244: ,pay_assignment_actions paa1
245: ,pay_payroll_actions ppa1
246: ,pay_all_payrolls_f ppf
247: WHERE ptp.time_period_id = pai_emp.action_information16
248: AND pai_emp.action_context_type = 'AAP'
249: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 279: ,pay_payroll_actions ppa1

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'
283: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 300: ,pay_payroll_actions ppa1

296: ,ppf.payroll_id
297: FROM per_time_periods ptp
298: ,pay_action_information pai_emp
299: ,pay_assignment_actions paa1
300: ,pay_payroll_actions ppa1
301: ,pay_all_payrolls_f ppf
302: WHERE ptp.time_period_id = pai_emp.action_information16
303: AND pai_emp.action_context_type = 'AAP'
304: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 324: ,pay_payroll_actions ppa1

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'
328: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 352: ,pay_payroll_actions ppa1

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'
356: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 383: ,pay_payroll_actions ppa1

379: SELECT distinct ppf.payroll_id
380: FROM per_time_periods ptp
381: ,pay_action_information pai_emp
382: ,pay_assignment_actions paa1
383: ,pay_payroll_actions ppa1
384: ,pay_all_payrolls_f ppf
385: WHERE ptp.time_period_id = pai_emp.action_information16
386: AND pai_emp.action_context_type = 'AAP'
387: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 416: ,pay_payroll_actions ppa1

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'
420: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 464: ,pay_payroll_actions ppa1

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
468: AND pai_emp.action_context_id = pai_emp1.action_context_id

Line 507: ,pay_payroll_actions ppa1

503: FROM per_time_periods ptp
504: ,pay_action_information pai_emp
505: ,pay_action_information pai_emp1
506: ,pay_assignment_actions paa1
507: ,pay_payroll_actions ppa1
508: ,pay_all_payrolls_f ppf
509: WHERE ptp.payroll_id = l_payroll_id
510: AND ptp.time_period_id = pai_emp.action_information16
511: AND pai_emp.action_context_id = pai_emp1.action_context_id

Line 557: pay_payroll_actions ppa,

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,
559: pay_emea_payment_values_v pet
560: WHERE
561: lck.locked_action_id = paa1.assignment_action_id AND

Line 603: pay_payroll_actions ppa,

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,
605: pay_emea_payment_values_v pet
606: WHERE
607: lck.locked_action_id = paa1.assignment_action_id AND

Line 637: ,pay_payroll_actions ppa

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
640: AND pen.action_context_id = pai.locking_action_id
641: AND pai.locked_action_id = paa.assignment_action_id

Line 667: ,pay_payroll_actions ppa1

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'
671: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 698: ,pay_payroll_actions ppa1

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'
702: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 728: ,pay_payroll_actions ppa1

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
732: WHERE paa.payroll_action_id = pai_ele.action_context_id

Line 762: ,pay_payroll_actions ppa1

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'
766: and pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 813: ,pay_payroll_actions ppa1

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'
817: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 843: ,pay_payroll_actions ppa1

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
847: WHERE paa.payroll_action_id = pai_ele.action_context_id

Line 877: ,pay_payroll_actions ppa1

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'
881: and pai_emp.action_information_category = 'EMPLOYEE DETAILS'