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_INFORMATION

Line 161: ,pay_action_information pai_emp

157: CURSOR csr_get_orgs_for_payroll (l_payroll_id number , l_effective_date date) is
158: SELECT distinct pai_emp.action_information15 organization
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

Line 184: ,pay_action_information pai_emp

180: cursor csr_condition_one(l_organization_id number ,l_org_structure_version_id number,l_parent_id number, l_effective_date date ) is
181: SELECT distinct pai_emp.action_information15 organization
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

Line 217: ,pay_action_information pai_emp

213: cursor csr_condition_two(l_organization_id number , l_effective_date date) is
214: SELECT distinct pai_emp.action_information15 organization
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

Line 239: ,pay_action_information pai_emp

235: cursor csr_condition_three(l_effective_date date) is
236: SELECT distinct pai_emp.action_information15 organization
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

Line 261: ,pay_action_information pai_emp

257: /* CURSOR TO GET PAYROLL IDS DISTINCT */
258: cursor csr_distinct_pyrl(l_organization_id number ,l_org_structure_version_id number,l_parent_id number, l_effective_date date ) is
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

Line 294: ,pay_action_information pai_emp

290: /* CURSOR TO GET PAYROLL IDS DISTINCT FOR ORGANIZATION */
291: cursor csr_org_only_distinct_pyrl(l_organization_id number , l_effective_date date) is
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

Line 340: ,pay_action_information pai_emp

336: ,ppf.payroll_name
337: ,nvl(pai_emp1.action_information13,0) ytd_earning
338: ,nvl(pai_emp1.action_information4,0) ytd_deduction
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

Line 341: ,pay_action_information pai_emp1

337: ,nvl(pai_emp1.action_information13,0) ytd_earning
338: ,nvl(pai_emp1.action_information4,0) ytd_deduction
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

Line 374: FROM pay_action_information pai_ele

370: ,pay_v.action_context_id arch_assact
371: ,pay_v.narrative earn_element
372: ,pay_v.numeric_value earn_value
373: ,pai_ele.action_information7
374: FROM pay_action_information pai_ele
375: ,pay_emea_paymnts_action_info_v pay_v
376: ,pay_assignment_actions paa
377: WHERE paa.assignment_action_id = l_assact_id
378: AND paa.payroll_action_id = pai_ele.action_context_id

Line 395: pay_action_information pai,

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
399: paa1.source_action_id IS NULL AND

Line 422: FROM pay_action_information pai_ele

418: ,pay_v.action_context_id arch_assact
419: ,pay_v.narrative ded_element
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

Line 443: pay_action_information pai,

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
447: paa1.source_action_id IS NULL AND

Line 492: FROM pay_action_information pai_ele

488: CURSOR csr_get_sum_earn (l_org_structure_version_id number,
489: l_organization_id number , l_payroll_id number , l_effective_date date) IS
490: /*Modifying this cursor for bug 7307152
491: SELECT sum(pay_v.numeric_value)
492: FROM pay_action_information pai_ele
493: ,pay_emea_paymnts_action_info_v pay_v
494: ,pay_assignment_actions paa
495: WHERE paa.payroll_action_id = pai_ele.action_context_id
496: AND pai_ele.action_context_type = 'PA'

Line 504: ,pay_action_information pai_emp

500: AND pay_v.narrative = pai_ele.action_information4
501: AND pay_v.payment_type NOT IN ('F')
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

Line 530: FROM pay_action_information pai_ele,

526: AND ppa1.action_status = 'C'
527: AND paa1.action_status = 'C'
528: AND ptp.end_date = l_effective_date);*/
529: SELECT sum(pet.result_value)
530: FROM pay_action_information pai_ele,
531: pay_emea_payment_values_v pet,
532: pay_assignment_actions paa
533: WHERE paa.payroll_action_id = pai_ele.action_context_id
534: AND pai_ele.action_context_type = 'PA'

Line 543: ,pay_action_information pai_emp

539: AND pai_ele.action_information5 NOT IN ('F')
540: AND pet.input_value_id = pai_ele.action_information3
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

Line 575: ,pay_action_information pai_ele

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
579: AND pai_ele.action_context_type = 'PA'

Line 576: ,pay_action_information pai_emp

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
579: AND pai_ele.action_context_type = 'PA'
580: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'

Line 603: from pay_action_information pai_ele

599:
600: /***************************************/
601: /*
602: select SUM(pay_v.numeric_value)
603: from pay_action_information pai_ele
604: ,pay_emea_paymnts_action_info_v pay_v
605: ,pay_assignment_actions paa
606: where paa.payroll_action_id = pai_ele.action_context_id
607: and pai_ele.action_context_type = 'PA'

Line 616: ,pay_action_information pai_emp

612: and pay_v.payment_type not in ('F')
613: and paa.assignment_action_id in (
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

Line 638: ,pay_action_information pai_emp

634: */
635: CURSOR csr_SEOO_SPLIT_1 (l_organization_id number , l_payroll_id number , l_effective_date date) IS
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

Line 659: from pay_action_information pai_ele

655: and ptp.end_date = l_effective_date;
656: CURSOR csr_SEOO_SPLIT_2 (l_arch_assact number) IS
657: /*Modifying this cursor for bug 7307152
658: select SUM(pay_v.numeric_value)
659: from pay_action_information pai_ele
660: ,pay_emea_paymnts_action_info_v pay_v
661: ,pay_assignment_actions paa
662: where paa.payroll_action_id = pai_ele.action_context_id
663: and pai_ele.action_context_type = 'PA'

Line 671: from pay_action_information pai_ele

667: and pay_v.narrative = pai_ele.action_information4
668: and pay_v.payment_type not in ('F')
669: and paa.assignment_action_id = l_arch_assact;*/
670: select SUM(pet.result_value)
671: from pay_action_information pai_ele
672: ,pay_emea_payment_values_v pet
673: ,pay_assignment_actions paa
674: where paa.payroll_action_id = pai_ele.action_context_id
675: and pai_ele.action_context_type = 'PA'

Line 689: FROM pay_action_information pai_ele

685: CURSOR csr_get_sum_ded (l_org_structure_version_id number,
686: l_organization_id number , l_payroll_id number , l_effective_date date) IS
687: /*Modifying this cursor for bug 7307152
688: SELECT sum(pay_v.numeric_value)
689: FROM pay_action_information pai_ele
690: ,pay_emea_paymnts_action_info_v pay_v
691: ,pay_assignment_actions paa
692: WHERE paa.payroll_action_id = pai_ele.action_context_id
693: AND pai_ele.action_context_type = 'PA'

Line 701: ,pay_action_information pai_emp

697: AND pay_v.narrative = pai_ele.action_information4
698: AND pay_v.payment_type NOT IN ('F')
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

Line 727: FROM pay_action_information pai_ele,

723: AND ppa1.action_status = 'C'
724: AND paa1.action_status = 'C'
725: AND ptp.end_date = l_effective_date);*/
726: SELECT sum(pet.result_value)
727: FROM pay_action_information pai_ele,
728: pay_emea_payment_values_v pet,
729: pay_assignment_actions paa
730: WHERE paa.payroll_action_id = pai_ele.action_context_id
731: AND pai_ele.action_context_type = 'PA'

Line 740: ,pay_action_information pai_emp

736: AND pai_ele.action_information5 NOT IN ('F')
737: AND pet.input_value_id = pai_ele.action_information3
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

Line 772: ,pay_action_information pai_ele

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
776: AND pai_ele.action_context_type = 'PA'

Line 773: ,pay_action_information pai_emp

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
776: AND pai_ele.action_context_type = 'PA'
777: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'

Line 799: from pay_action_information pai_ele

795: AND ptp.end_date = l_effective_date;*/
796: /***************************************/
797: /*
798: select SUM(pay_v.numeric_value)
799: from pay_action_information pai_ele
800: ,pay_emea_paymnts_action_info_v pay_v
801: ,pay_assignment_actions paa
802: where paa.payroll_action_id = pai_ele.action_context_id
803: and pai_ele.action_context_type = 'PA'

Line 812: ,pay_action_information pai_emp

808: and pay_v.payment_type not in ('F')
809: and paa.assignment_action_id in (
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

Line 833: ,pay_action_information pai_emp

829: and ptp.end_date = l_effective_date);*/
830: CURSOR csr_SDOO_SPLIT_1 (l_organization_id number , l_payroll_id number , l_effective_date date) IS
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

Line 854: from pay_action_information pai_ele

850: and ptp.end_date = l_effective_date;
851: CURSOR csr_SDOO_SPLIT_2 (l_arch_assact number) IS
852: /*Modifying this cursor for bug 7307152
853: select SUM(pay_v.numeric_value)
854: from pay_action_information pai_ele
855: ,pay_emea_paymnts_action_info_v pay_v
856: ,pay_assignment_actions paa
857: where paa.payroll_action_id = pai_ele.action_context_id
858: and pai_ele.action_context_type = 'PA'

Line 866: from pay_action_information pai_ele

862: and pay_v.narrative = pai_ele.action_information4
863: and pay_v.payment_type not in ('F')
864: and paa.assignment_action_id = l_arch_assact;*/
865: select SUM(pet.result_value)
866: from pay_action_information pai_ele
867: ,pay_emea_payment_values_v pet
868: ,pay_assignment_actions paa
869: where paa.payroll_action_id = pai_ele.action_context_id
870: and pai_ele.action_context_type = 'PA'