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_AE_PAYROLL_REGISTER dependencies on PAY_PAYROLL_ACTIONS

Line 165: ,pay_payroll_actions ppa1

161: FROM per_time_periods ptp
162: ,pay_action_information pai_emp
163: ,pay_assignment_actions paa1
164: ,pay_action_interlocks lck
165: ,pay_payroll_actions ppa1
166: ,pay_all_payrolls_f ppf
167: WHERE ptp.payroll_id = l_payroll_id
168: AND ptp.time_period_id = pai_emp.action_information16
169: AND pai_emp.action_context_type = 'AAP'

Line 187: ,pay_payroll_actions ppa1

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

Line 212: ,pay_payroll_actions ppa1

208: FROM per_time_periods ptp
209: ,pay_action_information pai_emp
210: ,pay_assignment_actions paa1
211: ,pay_action_interlocks lck
212: ,pay_payroll_actions ppa1
213: ,pay_all_payrolls_f ppf
214: WHERE ptp.time_period_id = pai_emp.action_information16
215: AND pai_emp.action_context_type = 'AAP'
216: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 244: ,pay_payroll_actions ppa1

240: ,ppf.payroll_id
241: FROM per_time_periods ptp
242: ,pay_action_information pai_emp
243: ,pay_assignment_actions paa1
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'
248: 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 301: ,pay_payroll_actions ppa1

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

Line 325: ,pay_payroll_actions ppa1

321: FROM per_time_periods ptp
322: ,pay_action_information pai_emp
323: ,pay_assignment_actions paa1
324: ,pay_action_interlocks lck
325: ,pay_payroll_actions ppa1
326: ,pay_all_payrolls_f ppf
327: WHERE ptp.time_period_id = pai_emp.action_information16
328: AND pai_emp.action_context_type = 'AAP'
329: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 354: ,pay_payroll_actions ppa1

350: FROM per_time_periods ptp
351: ,pay_action_information pai_emp
352: ,pay_assignment_actions paa1
353: ,pay_action_interlocks lck
354: ,pay_payroll_actions ppa1
355: ,pay_all_payrolls_f ppf
356: WHERE ptp.time_period_id = pai_emp.action_information16
357: AND pai_emp.action_context_type = 'AAP'
358: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 385: ,pay_payroll_actions ppa1

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

Line 418: ,pay_payroll_actions ppa1

414: FROM per_time_periods ptp
415: ,pay_action_information pai_emp
416: ,pay_assignment_actions paa1
417: ,pay_action_interlocks lck
418: ,pay_payroll_actions ppa1
419: ,pay_all_payrolls_f ppf
420: WHERE ptp.time_period_id = pai_emp.action_information16
421: AND pai_emp.action_context_type = 'AAP'
422: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 466: ,pay_payroll_actions ppa1

462: ,pay_action_information pai_emp
463: ,pay_action_information pai_emp1
464: ,pay_assignment_actions paa1
465: ,pay_action_interlocks lck
466: ,pay_payroll_actions ppa1
467: ,pay_all_payrolls_f ppf
468: WHERE ptp.payroll_id = l_payroll_id
469: AND ptp.time_period_id = pai_emp.action_information16
470: AND pai_emp.action_context_id = pai_emp1.action_context_id

Line 509: ,pay_payroll_actions ppa1

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

Line 559: pay_payroll_actions ppa,

555: FROM
556: pay_action_interlocks lck,
557: pay_assignment_actions paa1,
558: pay_assignment_actions paa2,
559: pay_payroll_actions ppa,
560: pay_action_information pai,
561: pay_emea_payment_values_v pet
562: WHERE
563: lck.locked_action_id = paa1.assignment_action_id AND

Line 607: pay_payroll_actions ppa,

603: FROM
604: pay_action_interlocks lck,
605: pay_assignment_actions paa1,
606: pay_assignment_actions paa2,
607: pay_payroll_actions ppa,
608: pay_action_information pai,
609: pay_emea_payment_values_v pet
610: WHERE
611: lck.locked_action_id = paa1.assignment_action_id AND

Line 640: ,pay_payroll_actions ppa

636: ,pay_assignment_actions_pkg.get_payment_status(paa.assignment_action_id,ppp.pre_payment_id) status
637: FROM pay_emp_net_dist_action_info_v pen
638: ,pay_action_interlocks pai
639: ,pay_assignment_actions paa
640: ,pay_payroll_actions ppa
641: ,pay_pre_payments ppp
642: WHERE pen.action_context_id = l_assact_id
643: AND pen.action_context_id = pai.locking_action_id
644: AND pai.locked_action_id = paa.assignment_action_id

Line 672: ,pay_payroll_actions ppa1

668: FROM per_time_periods ptp
669: ,pay_action_information pai_emp
670: ,pay_assignment_actions paa1
671: ,pay_action_interlocks lck
672: ,pay_payroll_actions ppa1
673: WHERE ptp.payroll_id = l_payroll_id
674: AND ptp.time_period_id = pai_emp.action_information16
675: AND pai_emp.action_context_type = 'AAP'
676: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 711: ,pay_payroll_actions ppa1

707: FROM per_time_periods ptp
708: ,pay_action_information pai_emp
709: ,pay_assignment_actions paa1
710: ,pay_action_interlocks lck
711: ,pay_payroll_actions ppa1
712: WHERE ptp.payroll_id = l_payroll_id
713: AND ptp.time_period_id = pai_emp.action_information16
714: AND pai_emp.action_context_type = 'AAP'
715: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 739: ,pay_payroll_actions ppa1

735: FROM pay_assignment_actions paa
736: ,per_time_periods ptp
737: ,pay_assignment_actions paa1
738: ,pay_action_interlocks lck
739: ,pay_payroll_actions ppa1
740: ,pay_action_information pai_ele
741: ,pay_action_information pai_emp
742: ,pay_emea_paymnts_action_info_v pay_v
743: WHERE paa.payroll_action_id = pai_ele.action_context_id

Line 784: ,pay_payroll_actions ppa1

780: from per_time_periods ptp
781: ,pay_action_information pai_emp
782: ,pay_assignment_actions paa1
783: ,pay_action_interlocks lck
784: ,pay_payroll_actions ppa1
785: where ptp.payroll_id = l_payroll_id
786: and ptp.time_period_id = pai_emp.action_information16
787: and pai_emp.action_context_type = 'AAP'
788: and pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 806: ,pay_payroll_actions ppa1

802: from per_time_periods ptp
803: ,pay_action_information pai_emp
804: ,pay_assignment_actions paa1
805: ,pay_action_interlocks lck
806: ,pay_payroll_actions ppa1
807: where ptp.payroll_id = l_payroll_id
808: and ptp.time_period_id = pai_emp.action_information16
809: and pai_emp.action_context_type = 'AAP'
810: and pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 869: ,pay_payroll_actions ppa1

865: FROM per_time_periods ptp
866: ,pay_action_information pai_emp
867: ,pay_assignment_actions paa1
868: ,pay_action_interlocks lck
869: ,pay_payroll_actions ppa1
870: WHERE ptp.payroll_id = l_payroll_id
871: AND ptp.time_period_id = pai_emp.action_information16
872: AND pai_emp.action_context_type = 'AAP'
873: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 908: ,pay_payroll_actions ppa1

904: FROM per_time_periods ptp
905: ,pay_action_information pai_emp
906: ,pay_assignment_actions paa1
907: ,pay_action_interlocks lck
908: ,pay_payroll_actions ppa1
909: WHERE ptp.payroll_id = l_payroll_id
910: AND ptp.time_period_id = pai_emp.action_information16
911: AND pai_emp.action_context_type = 'AAP'
912: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 936: ,pay_payroll_actions ppa1

932: FROM pay_assignment_actions paa
933: ,per_time_periods ptp
934: ,pay_assignment_actions paa1
935: ,pay_action_interlocks lck
936: ,pay_payroll_actions ppa1
937: ,pay_action_information pai_ele
938: ,pay_action_information pai_emp
939: ,pay_emea_paymnts_action_info_v pay_v
940: WHERE paa.payroll_action_id = pai_ele.action_context_id

Line 980: ,pay_payroll_actions ppa1

976: from per_time_periods ptp
977: ,pay_action_information pai_emp
978: ,pay_assignment_actions paa1
979: ,pay_action_interlocks lck
980: ,pay_payroll_actions ppa1
981: where ptp.payroll_id = l_payroll_id
982: and ptp.time_period_id = pai_emp.action_information16
983: and pai_emp.action_context_type = 'AAP'
984: and pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 1001: ,pay_payroll_actions ppa1

997: from per_time_periods ptp
998: ,pay_action_information pai_emp
999: ,pay_assignment_actions paa1
1000: ,pay_action_interlocks lck
1001: ,pay_payroll_actions ppa1
1002: where ptp.payroll_id = l_payroll_id
1003: and ptp.time_period_id = pai_emp.action_information16
1004: and pai_emp.action_context_type = 'AAP'
1005: and pai_emp.action_information_category = 'EMPLOYEE DETAILS'