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 163: ,pay_action_interlocks lck

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

Line 186: ,pay_action_interlocks lck

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

Line 219: ,pay_action_interlocks lck

215: ,ppf.payroll_id
216: FROM per_time_periods ptp
217: ,pay_action_information pai_emp
218: ,pay_assignment_actions paa1
219: ,pay_action_interlocks lck
220: ,pay_payroll_actions ppa1
221: ,pay_all_payrolls_f ppf
222: WHERE ptp.time_period_id = pai_emp.action_information16
223: AND pai_emp.action_context_type = 'AAP'

Line 241: ,pay_action_interlocks lck

237: ,ppf.payroll_id
238: FROM per_time_periods ptp
239: ,pay_action_information pai_emp
240: ,pay_assignment_actions paa1
241: ,pay_action_interlocks lck
242: ,pay_payroll_actions ppa1
243: ,pay_all_payrolls_f ppf
244: WHERE ptp.time_period_id = pai_emp.action_information16
245: AND pai_emp.action_context_type = 'AAP'

Line 263: ,pay_action_interlocks lck

259: SELECT distinct ppf.payroll_id
260: FROM per_time_periods ptp
261: ,pay_action_information pai_emp
262: ,pay_assignment_actions paa1
263: ,pay_action_interlocks lck
264: ,pay_payroll_actions ppa1
265: ,pay_all_payrolls_f ppf
266: WHERE ptp.time_period_id = pai_emp.action_information16
267: AND pai_emp.action_context_type = 'AAP'

Line 296: ,pay_action_interlocks lck

292: SELECT distinct ppf.payroll_id
293: FROM per_time_periods ptp
294: ,pay_action_information pai_emp
295: ,pay_assignment_actions paa1
296: ,pay_action_interlocks lck
297: ,pay_payroll_actions ppa1
298: ,pay_all_payrolls_f ppf
299: WHERE ptp.time_period_id = pai_emp.action_information16
300: AND pai_emp.action_context_type = 'AAP'

Line 343: ,pay_action_interlocks lck

339: FROM per_time_periods ptp
340: ,pay_action_information pai_emp
341: ,pay_action_information pai_emp1
342: ,pay_assignment_actions paa1
343: ,pay_action_interlocks lck
344: ,pay_payroll_actions ppa1
345: ,pay_all_payrolls_f ppf
346: WHERE ptp.payroll_id = l_payroll_id
347: AND ptp.time_period_id = pai_emp.action_information16

Line 391: pay_action_interlocks lck,

387: ,pai.action_information4 earn_element
388: ,pet.result_value earn_value
389: ,pai.action_information7
390: FROM
391: pay_action_interlocks lck,
392: pay_assignment_actions paa1,
393: pay_assignment_actions paa2,
394: pay_payroll_actions ppa,
395: pay_action_information pai,

Line 439: pay_action_interlocks lck,

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,

Line 473: ,pay_action_interlocks pai

469: ,pen.value pay_amount
470: ,pen.action_context_id
471: ,pay_assignment_actions_pkg.get_payment_status(paa.assignment_action_id,ppp.pre_payment_id) status
472: FROM pay_emp_net_dist_action_info_v pen
473: ,pay_action_interlocks pai
474: ,pay_assignment_actions paa
475: ,pay_payroll_actions ppa
476: ,pay_pre_payments ppp
477: WHERE pen.action_context_id = l_assact_id

Line 506: ,pay_action_interlocks lck

502: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
503: FROM per_time_periods ptp
504: ,pay_action_information pai_emp
505: ,pay_assignment_actions paa1
506: ,pay_action_interlocks lck
507: ,pay_payroll_actions ppa1
508: WHERE ptp.payroll_id = l_payroll_id
509: AND ptp.time_period_id = pai_emp.action_information16
510: AND pai_emp.action_context_type = 'AAP'

Line 545: ,pay_action_interlocks lck

541: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
542: FROM per_time_periods ptp
543: ,pay_action_information pai_emp
544: ,pay_assignment_actions paa1
545: ,pay_action_interlocks lck
546: ,pay_payroll_actions ppa1
547: WHERE ptp.payroll_id = l_payroll_id
548: AND ptp.time_period_id = pai_emp.action_information16
549: AND pai_emp.action_context_type = 'AAP'

Line 573: ,pay_action_interlocks lck

569: /*SELECT sum(pay_v.numeric_value)
570: FROM pay_assignment_actions paa
571: ,per_time_periods ptp
572: ,pay_assignment_actions paa1
573: ,pay_action_interlocks lck
574: ,pay_payroll_actions ppa1
575: ,pay_action_information pai_ele
576: ,pay_action_information pai_emp
577: ,pay_emea_paymnts_action_info_v pay_v

Line 618: ,pay_action_interlocks lck

614: select pai_emp.action_context_id arch_assact
615: from per_time_periods ptp
616: ,pay_action_information pai_emp
617: ,pay_assignment_actions paa1
618: ,pay_action_interlocks lck
619: ,pay_payroll_actions ppa1
620: where ptp.payroll_id = l_payroll_id
621: and ptp.time_period_id = pai_emp.action_information16
622: and pai_emp.action_context_type = 'AAP'

Line 640: ,pay_action_interlocks lck

636: select pai_emp.action_context_id arch_assact
637: from per_time_periods ptp
638: ,pay_action_information pai_emp
639: ,pay_assignment_actions paa1
640: ,pay_action_interlocks lck
641: ,pay_payroll_actions ppa1
642: where ptp.payroll_id = l_payroll_id
643: and ptp.time_period_id = pai_emp.action_information16
644: and pai_emp.action_context_type = 'AAP'

Line 703: ,pay_action_interlocks lck

699: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
700: FROM per_time_periods ptp
701: ,pay_action_information pai_emp
702: ,pay_assignment_actions paa1
703: ,pay_action_interlocks lck
704: ,pay_payroll_actions ppa1
705: WHERE ptp.payroll_id = l_payroll_id
706: AND ptp.time_period_id = pai_emp.action_information16
707: AND pai_emp.action_context_type = 'AAP'

Line 742: ,pay_action_interlocks lck

738: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
739: FROM per_time_periods ptp
740: ,pay_action_information pai_emp
741: ,pay_assignment_actions paa1
742: ,pay_action_interlocks lck
743: ,pay_payroll_actions ppa1
744: WHERE ptp.payroll_id = l_payroll_id
745: AND ptp.time_period_id = pai_emp.action_information16
746: AND pai_emp.action_context_type = 'AAP'

Line 770: ,pay_action_interlocks lck

766: /*SELECT sum(pay_v.numeric_value)
767: FROM pay_assignment_actions paa
768: ,per_time_periods ptp
769: ,pay_assignment_actions paa1
770: ,pay_action_interlocks lck
771: ,pay_payroll_actions ppa1
772: ,pay_action_information pai_ele
773: ,pay_action_information pai_emp
774: ,pay_emea_paymnts_action_info_v pay_v

Line 814: ,pay_action_interlocks lck

810: select pai_emp.action_context_id arch_assact
811: from per_time_periods ptp
812: ,pay_action_information pai_emp
813: ,pay_assignment_actions paa1
814: ,pay_action_interlocks lck
815: ,pay_payroll_actions ppa1
816: where ptp.payroll_id = l_payroll_id
817: and ptp.time_period_id = pai_emp.action_information16
818: and pai_emp.action_context_type = 'AAP'

Line 835: ,pay_action_interlocks lck

831: select pai_emp.action_context_id arch_assact
832: from per_time_periods ptp
833: ,pay_action_information pai_emp
834: ,pay_assignment_actions paa1
835: ,pay_action_interlocks lck
836: ,pay_payroll_actions ppa1
837: where ptp.payroll_id = l_payroll_id
838: and ptp.time_period_id = pai_emp.action_information16
839: and pai_emp.action_context_type = 'AAP'