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 164: ,pay_payroll_actions ppa1

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

Line 187: ,pay_payroll_actions ppa1

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

Line 220: ,pay_payroll_actions ppa1

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

Line 242: ,pay_payroll_actions ppa1

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

Line 264: ,pay_payroll_actions ppa1

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

Line 297: ,pay_payroll_actions ppa1

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

Line 344: ,pay_payroll_actions ppa1

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

Line 394: pay_payroll_actions ppa,

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,
396: pay_emea_payment_values_v pet
397: WHERE
398: lck.locked_action_id = paa1.assignment_action_id AND

Line 442: pay_payroll_actions ppa,

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,
444: pay_emea_payment_values_v pet
445: WHERE
446: lck.locked_action_id = paa1.assignment_action_id AND

Line 475: ,pay_payroll_actions ppa

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

Line 507: ,pay_payroll_actions ppa1

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

Line 546: ,pay_payroll_actions ppa1

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

Line 574: ,pay_payroll_actions ppa1

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

Line 619: ,pay_payroll_actions ppa1

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

Line 641: ,pay_payroll_actions ppa1

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

Line 704: ,pay_payroll_actions ppa1

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

Line 743: ,pay_payroll_actions ppa1

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

Line 771: ,pay_payroll_actions ppa1

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

Line 815: ,pay_payroll_actions ppa1

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

Line 836: ,pay_payroll_actions ppa1

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