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

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

Line 189: ,pay_payroll_actions ppa1

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

Line 222: ,pay_payroll_actions ppa1

218: FROM per_time_periods ptp
219: ,pay_action_information pai_emp
220: ,pay_assignment_actions paa1
221: ,pay_action_interlocks lck
222: ,pay_payroll_actions ppa1
223: ,pay_all_payrolls_f ppf
224: WHERE ptp.time_period_id = pai_emp.action_information16
225: AND pai_emp.action_context_type = 'AAP'
226: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 244: ,pay_payroll_actions ppa1

240: FROM per_time_periods ptp
241: ,pay_action_information pai_emp
242: ,pay_assignment_actions paa1
243: ,pay_action_interlocks lck
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 266: ,pay_payroll_actions ppa1

262: FROM per_time_periods ptp
263: ,pay_action_information pai_emp
264: ,pay_assignment_actions paa1
265: ,pay_action_interlocks lck
266: ,pay_payroll_actions ppa1
267: ,pay_all_payrolls_f ppf
268: WHERE ptp.time_period_id = pai_emp.action_information16
269: AND pai_emp.action_context_type = 'AAP'
270: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 299: ,pay_payroll_actions ppa1

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

Line 346: ,pay_payroll_actions ppa1

342: ,pay_action_information pai_emp
343: ,pay_action_information pai_emp1
344: ,pay_assignment_actions paa1
345: ,pay_action_interlocks lck
346: ,pay_payroll_actions ppa1
347: ,pay_all_payrolls_f ppf
348: WHERE ptp.payroll_id = l_payroll_id
349: AND ptp.time_period_id = pai_emp.action_information16
350: AND pai_emp.action_context_id = pai_emp1.action_context_id

Line 396: pay_payroll_actions ppa,

392: FROM
393: pay_action_interlocks lck,
394: pay_assignment_actions paa1,
395: pay_assignment_actions paa2,
396: pay_payroll_actions ppa,
397: pay_action_information pai,
398: pay_emea_payment_values_v pet
399: WHERE
400: 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 476: ,pay_payroll_actions ppa

472: ,pay_assignment_actions_pkg.get_payment_status(paa.assignment_action_id,ppp.pre_payment_id) status
473: FROM pay_emp_net_dist_action_info_v pen
474: ,pay_action_interlocks pai
475: ,pay_assignment_actions paa
476: ,pay_payroll_actions ppa
477: ,pay_pre_payments ppp
478: WHERE pen.action_context_id = l_assact_id
479: AND pen.action_context_id = pai.locking_action_id
480: AND pai.locked_action_id = paa.assignment_action_id

Line 506: ,pay_payroll_actions ppa1

502: FROM per_time_periods ptp
503: ,pay_action_information pai_emp
504: ,pay_assignment_actions paa1
505: ,pay_action_interlocks lck
506: ,pay_payroll_actions ppa1
507: WHERE ptp.payroll_id = l_payroll_id
508: AND ptp.time_period_id = pai_emp.action_information16
509: AND pai_emp.action_context_type = 'AAP'
510: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 537: ,pay_payroll_actions ppa1

533: FROM per_time_periods ptp
534: ,pay_action_information pai_emp
535: ,pay_assignment_actions paa1
536: ,pay_action_interlocks lck
537: ,pay_payroll_actions ppa1
538: WHERE ptp.payroll_id = l_payroll_id
539: AND ptp.time_period_id = pai_emp.action_information16
540: AND pai_emp.action_context_type = 'AAP'
541: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 567: ,pay_payroll_actions ppa1

563: FROM pay_assignment_actions paa
564: ,per_time_periods ptp
565: ,pay_assignment_actions paa1
566: ,pay_action_interlocks lck
567: ,pay_payroll_actions ppa1
568: ,pay_action_information pai_ele
569: ,pay_action_information pai_emp
570: ,pay_emea_paymnts_action_info_v pay_v
571: WHERE paa.payroll_action_id = pai_ele.action_context_id

Line 601: ,pay_payroll_actions ppa1

597: from per_time_periods ptp
598: ,pay_action_information pai_emp
599: ,pay_assignment_actions paa1
600: ,pay_action_interlocks lck
601: ,pay_payroll_actions ppa1
602: where ptp.payroll_id = l_payroll_id
603: and ptp.time_period_id = pai_emp.action_information16
604: and pai_emp.action_context_type = 'AAP'
605: and pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 652: ,pay_payroll_actions ppa1

648: FROM per_time_periods ptp
649: ,pay_action_information pai_emp
650: ,pay_assignment_actions paa1
651: ,pay_action_interlocks lck
652: ,pay_payroll_actions ppa1
653: WHERE ptp.payroll_id = l_payroll_id
654: AND ptp.time_period_id = pai_emp.action_information16
655: AND pai_emp.action_context_type = 'AAP'
656: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 682: ,pay_payroll_actions ppa1

678: FROM pay_assignment_actions paa
679: ,per_time_periods ptp
680: ,pay_assignment_actions paa1
681: ,pay_action_interlocks lck
682: ,pay_payroll_actions ppa1
683: ,pay_action_information pai_ele
684: ,pay_action_information pai_emp
685: ,pay_emea_paymnts_action_info_v pay_v
686: WHERE paa.payroll_action_id = pai_ele.action_context_id

Line 716: ,pay_payroll_actions ppa1

712: from per_time_periods ptp
713: ,pay_action_information pai_emp
714: ,pay_assignment_actions paa1
715: ,pay_action_interlocks lck
716: ,pay_payroll_actions ppa1
717: where ptp.payroll_id = l_payroll_id
718: and ptp.time_period_id = pai_emp.action_information16
719: and pai_emp.action_context_type = 'AAP'
720: and pai_emp.action_information_category = 'EMPLOYEE DETAILS'