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_ASSIGNMENT_ACTIONS

Line 164: ,pay_assignment_actions paa1

160: SELECT distinct pai_emp.action_information15 organization
161: ,ppf.payroll_id
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

Line 187: ,pay_assignment_actions paa1

183: SELECT distinct pai_emp.action_information15 organization
184: ,ppf.payroll_id
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

Line 220: ,pay_assignment_actions paa1

216: SELECT distinct pai_emp.action_information15 organization
217: ,ppf.payroll_id
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

Line 242: ,pay_assignment_actions paa1

238: SELECT distinct pai_emp.action_information15 organization
239: ,ppf.payroll_id
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

Line 264: ,pay_assignment_actions paa1

260: cursor csr_distinct_pyrl(l_organization_id number ,l_org_structure_version_id number,l_parent_id number, l_effective_date date ) is
261: SELECT distinct ppf.payroll_id
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

Line 297: ,pay_assignment_actions paa1

293: cursor csr_org_only_distinct_pyrl(l_organization_id number , l_effective_date date) is
294: SELECT distinct ppf.payroll_id
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

Line 344: ,pay_assignment_actions paa1

340: ,nvl(pai_emp1.action_information4,0) ytd_deduction
341: FROM per_time_periods ptp
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

Line 378: ,pay_assignment_actions paa

374: ,pay_v.numeric_value earn_value
375: ,pai_ele.action_information7
376: FROM pay_action_information pai_ele
377: ,pay_emea_paymnts_action_info_v pay_v
378: ,pay_assignment_actions paa
379: WHERE paa.assignment_action_id = l_assact_id
380: AND paa.payroll_action_id = pai_ele.action_context_id
381: AND pai_ele.action_context_type = 'PA'
382: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'

Line 394: pay_assignment_actions paa1,

390: ,pet.result_value earn_value
391: ,pai.action_information7
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

Line 395: pay_assignment_actions paa2,

391: ,pai.action_information7
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

Line 424: ,pay_assignment_actions paa

420: ,pay_v.numeric_value ded_value
421: ,pai_ele.action_information7
422: FROM pay_action_information pai_ele
423: ,pay_emea_paymnts_action_info_v pay_v
424: ,pay_assignment_actions paa
425: WHERE paa.assignment_action_id= l_assact_id
426: AND paa.payroll_action_id = pai_ele.action_context_id
427: AND pai_ele.action_context_type = 'PA'
428: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'

Line 440: pay_assignment_actions paa1,

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,
444: pay_emea_payment_values_v pet

Line 441: pay_assignment_actions paa2,

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,
444: pay_emea_payment_values_v pet
445: WHERE

Line 472: ,pay_assignment_actions_pkg.get_payment_status(paa.assignment_action_id,ppp.pre_payment_id) status

468: ,pen.segment2 branch_name
469: ,pen.segment4 account_number
470: ,pen.value pay_amount
471: ,pen.action_context_id
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

Line 475: ,pay_assignment_actions paa

471: ,pen.action_context_id
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

Line 493: ,pay_assignment_actions paa

489: /*CURSOR csr_get_sum_earn_summary (l_org_name varchar2 , l_payroll_id number , l_effective_date date) IS
490: SELECT sum(pay_v.numeric_value)
491: FROM pay_action_information pai_ele
492: ,pay_emea_paymnts_action_info_v pay_v
493: ,pay_assignment_actions paa
494: WHERE paa.payroll_action_id = pai_ele.action_context_id
495: AND pai_ele.action_context_type = 'PA'
496: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'
497: AND pai_ele.action_information7 IN ('E')

Line 504: ,pay_assignment_actions paa1

500: AND pay_v.payment_type NOT IN ('F')
501: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
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

Line 524: ,pay_assignment_actions paa

520: l_organization_id number , l_payroll_id number , l_effective_date date) IS
521: SELECT sum(pay_v.numeric_value)
522: FROM pay_action_information pai_ele
523: ,pay_emea_paymnts_action_info_v pay_v
524: ,pay_assignment_actions paa
525: WHERE paa.payroll_action_id = pai_ele.action_context_id
526: AND pai_ele.action_context_type = 'PA'
527: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'
528: AND pai_ele.action_information7 IN ('E')

Line 535: ,pay_assignment_actions paa1

531: AND pay_v.payment_type NOT IN ('F')
532: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
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

Line 563: FROM pay_assignment_actions paa

559: /****Cursor split into 2 for fixing performance bug
560: CURSOR csr_get_sum_earn_only_org (l_organization_id number , l_payroll_id number , l_effective_date date) IS
561: --*******Fixed during performance bugs*****
562: SELECT sum(pay_v.numeric_value)
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

Line 565: ,pay_assignment_actions paa1

561: --*******Fixed during performance bugs*****
562: SELECT sum(pay_v.numeric_value)
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

Line 599: ,pay_assignment_actions paa1

595: CURSOR csr_seoo_split_1 (l_organization_id number , l_payroll_id number , l_effective_date date) IS
596: select pai_emp.action_context_id arch_assact
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

Line 620: ,pay_assignment_actions paa

616: CURSOR csr_seoo_split_2 (l_arch_assact number) IS
617: select SUM(pay_v.numeric_value)
618: from pay_action_information pai_ele
619: ,pay_emea_paymnts_action_info_v pay_v
620: ,pay_assignment_actions paa
621: where paa.payroll_action_id = pai_ele.action_context_id
622: and pai_ele.action_context_type = 'PA'
623: and pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'
624: and pai_ele.action_information7 in ('E')

Line 639: ,pay_assignment_actions paa

635: l_organization_id number , l_payroll_id number , l_effective_date date) IS
636: SELECT sum(pay_v.numeric_value)
637: FROM pay_action_information pai_ele
638: ,pay_emea_paymnts_action_info_v pay_v
639: ,pay_assignment_actions paa
640: WHERE paa.payroll_action_id = pai_ele.action_context_id
641: AND pai_ele.action_context_type = 'PA'
642: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'
643: AND pai_ele.action_information7 IN ('D')

Line 650: ,pay_assignment_actions paa1

646: AND pay_v.payment_type NOT IN ('F')
647: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
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

Line 678: FROM pay_assignment_actions paa

674: /****Cursor split into 2 for fixing performance bug
675: CURSOR csr_get_sum_ded_only_org (l_organization_id number , l_payroll_id number , l_effective_date date) IS
676: --******* Fixed during performance bugs*******
677: SELECT sum(pay_v.numeric_value)
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

Line 680: ,pay_assignment_actions paa1

676: --******* Fixed during performance bugs*******
677: SELECT sum(pay_v.numeric_value)
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

Line 714: ,pay_assignment_actions paa1

710: CURSOR csr_sdoo_split_1 (l_organization_id number , l_payroll_id number , l_effective_date date) IS
711: select pai_emp.action_context_id arch_assact
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

Line 735: ,pay_assignment_actions paa

731: CURSOR csr_sdoo_split_2 (l_arch_assact number) IS
732: select SUM(pay_v.numeric_value)
733: from pay_action_information pai_ele
734: ,pay_emea_paymnts_action_info_v pay_v
735: ,pay_assignment_actions paa
736: where paa.payroll_action_id = pai_ele.action_context_id
737: and pai_ele.action_context_type = 'PA'
738: and pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'
739: and pai_ele.action_information7 in ('D')