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_ACTION_INTERLOCKS

Line 164: ,pay_action_interlocks lck

160: ,ppf.payroll_id
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

Line 211: ,pay_action_interlocks lck

207: ,ppf.payroll_id
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'

Line 278: ,pay_action_interlocks lck

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'

Line 324: ,pay_action_interlocks lck

320: ,ppf.payroll_id
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'

Line 353: ,pay_action_interlocks lck

349: SELECT distinct ppf.payroll_id
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'

Line 417: ,pay_action_interlocks lck

413: SELECT distinct ppf.payroll_id
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'

Line 465: ,pay_action_interlocks lck

461: FROM per_time_periods ptp
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

Line 556: pay_action_interlocks lck,

552: ,pai.action_information4 earn_element
553: ,pet.result_value earn_value
554: ,pai.action_information7
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,

Line 604: pay_action_interlocks lck,

600: ,pai.action_information4 ded_element
601: ,pet.result_value ded_value
602: ,pai.action_information7
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,

Line 638: ,pay_action_interlocks pai

634: ,pen.value pay_amount
635: ,pen.action_context_id
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

Line 671: ,pay_action_interlocks lck

667: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
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'

Line 710: ,pay_action_interlocks lck

706: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
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'

Line 738: ,pay_action_interlocks lck

734: /*SELECT sum(pay_v.numeric_value)
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

Line 783: ,pay_action_interlocks lck

779: select pai_emp.action_context_id arch_assact
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'

Line 805: ,pay_action_interlocks lck

801: select pai_emp.action_context_id arch_assact
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'

Line 868: ,pay_action_interlocks lck

864: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
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'

Line 907: ,pay_action_interlocks lck

903: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
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'

Line 935: ,pay_action_interlocks lck

931: /*SELECT sum(pay_v.numeric_value)
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

Line 979: ,pay_action_interlocks lck

975: select pai_emp.action_context_id arch_assact
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'

Line 1000: ,pay_action_interlocks lck

996: select pai_emp.action_context_id arch_assact
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'