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_ACTION_INFORMATION

Line 164: ,pay_action_information pai_emp

160: /*CURSOR csr_get_orgs_for_payroll (l_payroll_id number , l_effective_date date) is
161: SELECT distinct pai_emp.action_information15 organization
162: ,ppf.payroll_id
163: FROM per_time_periods ptp
164: ,pay_action_information pai_emp
165: ,pay_assignment_actions paa1
166: ,pay_action_interlocks lck
167: ,pay_payroll_actions ppa1
168: ,pay_all_payrolls_f ppf

Line 187: ,pay_action_information pai_emp

183: CURSOR csr_get_orgs_for_payroll (l_payroll_id number , l_effective_date date) is
184: SELECT distinct pai_emp.action_information15 organization
185: ,ppf.payroll_id
186: FROM per_time_periods ptp
187: ,pay_action_information pai_emp
188: ,pay_assignment_actions paa1
189: ,pay_payroll_actions ppa1
190: ,pay_all_payrolls_f ppf
191: WHERE ptp.payroll_id = l_payroll_id

Line 210: ,pay_action_information pai_emp

206: /*cursor csr_condition_one(l_organization_id number ,l_org_structure_version_id number,l_parent_id number, l_effective_date date ) is
207: SELECT distinct pai_emp.action_information15 organization
208: ,ppf.payroll_id
209: FROM per_time_periods ptp
210: ,pay_action_information pai_emp
211: ,pay_assignment_actions paa1
212: ,pay_action_interlocks lck
213: ,pay_payroll_actions ppa1
214: ,pay_all_payrolls_f ppf

Line 243: ,pay_action_information pai_emp

239: cursor csr_condition_one(l_organization_id number ,l_org_structure_version_id number,l_parent_id number, l_effective_date date ) is
240: SELECT distinct pai_emp.action_information15 organization
241: ,ppf.payroll_id
242: FROM per_time_periods ptp
243: ,pay_action_information pai_emp
244: ,pay_assignment_actions paa1
245: ,pay_payroll_actions ppa1
246: ,pay_all_payrolls_f ppf
247: WHERE ptp.time_period_id = pai_emp.action_information16

Line 276: ,pay_action_information pai_emp

272: /*cursor csr_condition_two(l_organization_id number , l_effective_date date) is
273: SELECT distinct pai_emp.action_information15 organization
274: ,ppf.payroll_id
275: FROM per_time_periods ptp
276: ,pay_action_information pai_emp
277: ,pay_assignment_actions paa1
278: ,pay_action_interlocks lck
279: ,pay_payroll_actions ppa1
280: ,pay_all_payrolls_f ppf

Line 298: ,pay_action_information pai_emp

294: cursor csr_condition_two(l_organization_id number , l_effective_date date) is
295: SELECT distinct pai_emp.action_information15 organization
296: ,ppf.payroll_id
297: FROM per_time_periods ptp
298: ,pay_action_information pai_emp
299: ,pay_assignment_actions paa1
300: ,pay_payroll_actions ppa1
301: ,pay_all_payrolls_f ppf
302: WHERE ptp.time_period_id = pai_emp.action_information16

Line 321: ,pay_action_information pai_emp

317: /*cursor csr_condition_three(l_effective_date date) is
318: SELECT distinct pai_emp.action_information15 organization
319: ,ppf.payroll_id
320: FROM per_time_periods ptp
321: ,pay_action_information pai_emp
322: ,pay_assignment_actions paa1
323: ,pay_action_interlocks lck
324: ,pay_payroll_actions ppa1
325: ,pay_all_payrolls_f ppf

Line 349: ,pay_action_information pai_emp

345: /* Modifyig the cursor for performance issue for Bug 7632337 */
346: /*cursor csr_distinct_pyrl(l_organization_id number ,l_org_structure_version_id number,l_parent_id number, l_effective_date date ) is
347: SELECT distinct ppf.payroll_id
348: FROM per_time_periods ptp
349: ,pay_action_information pai_emp
350: ,pay_assignment_actions paa1
351: ,pay_action_interlocks lck
352: ,pay_payroll_actions ppa1
353: ,pay_all_payrolls_f ppf

Line 381: ,pay_action_information pai_emp

377: from sys.dual) ; */
378: cursor csr_distinct_pyrl(l_organization_id number ,l_org_structure_version_id number,l_parent_id number, l_effective_date date ) is
379: SELECT distinct ppf.payroll_id
380: FROM per_time_periods ptp
381: ,pay_action_information pai_emp
382: ,pay_assignment_actions paa1
383: ,pay_payroll_actions ppa1
384: ,pay_all_payrolls_f ppf
385: WHERE ptp.time_period_id = pai_emp.action_information16

Line 413: ,pay_action_information pai_emp

409: /* CURSOR TO GET PAYROLL IDS DISTINCT FOR ORGANIZATION */
410: cursor csr_org_only_distinct_pyrl(l_organization_id number , l_effective_date date) is
411: SELECT distinct ppf.payroll_id
412: FROM per_time_periods ptp
413: ,pay_action_information pai_emp
414: ,pay_assignment_actions paa1
415: ,pay_action_interlocks lck
416: ,pay_payroll_actions ppa1
417: ,pay_all_payrolls_f ppf

Line 460: ,pay_action_information pai_emp

456: ,ppf.payroll_name
457: ,nvl(pai_emp1.action_information13,0) ytd_earning
458: ,nvl(pai_emp1.action_information4,0) ytd_deduction
459: FROM per_time_periods ptp
460: ,pay_action_information pai_emp
461: ,pay_action_information pai_emp1
462: ,pay_assignment_actions paa1
463: ,pay_action_interlocks lck
464: ,pay_payroll_actions ppa1

Line 461: ,pay_action_information pai_emp1

457: ,nvl(pai_emp1.action_information13,0) ytd_earning
458: ,nvl(pai_emp1.action_information4,0) ytd_deduction
459: FROM per_time_periods ptp
460: ,pay_action_information pai_emp
461: ,pay_action_information pai_emp1
462: ,pay_assignment_actions paa1
463: ,pay_action_interlocks lck
464: ,pay_payroll_actions ppa1
465: ,pay_all_payrolls_f ppf

Line 504: ,pay_action_information pai_emp

500: ,ppf.payroll_name
501: ,nvl(pai_emp1.action_information13,0) ytd_earning
502: ,nvl(pai_emp1.action_information4,0) ytd_deduction
503: FROM per_time_periods ptp
504: ,pay_action_information pai_emp
505: ,pay_action_information pai_emp1
506: ,pay_assignment_actions paa1
507: ,pay_payroll_actions ppa1
508: ,pay_all_payrolls_f ppf

Line 505: ,pay_action_information pai_emp1

501: ,nvl(pai_emp1.action_information13,0) ytd_earning
502: ,nvl(pai_emp1.action_information4,0) ytd_deduction
503: FROM per_time_periods ptp
504: ,pay_action_information pai_emp
505: ,pay_action_information pai_emp1
506: ,pay_assignment_actions paa1
507: ,pay_payroll_actions ppa1
508: ,pay_all_payrolls_f ppf
509: WHERE ptp.payroll_id = l_payroll_id

Line 537: FROM pay_action_information pai_ele

533: ,pay_v.action_context_id arch_assact
534: ,pay_v.narrative earn_element
535: ,pay_v.numeric_value earn_value
536: ,pai_ele.action_information7
537: FROM pay_action_information pai_ele
538: ,pay_emea_paymnts_action_info_v pay_v
539: ,pay_assignment_actions paa
540: WHERE paa.assignment_action_id = l_assact_id
541: AND paa.payroll_action_id = pai_ele.action_context_id

Line 558: pay_action_information pai,

554: pay_action_interlocks lck,
555: pay_assignment_actions paa1,
556: pay_assignment_actions paa2,
557: pay_payroll_actions ppa,
558: pay_action_information pai,
559: pay_emea_payment_values_v pet
560: WHERE
561: lck.locked_action_id = paa1.assignment_action_id AND
562: paa1.source_action_id IS NULL AND

Line 583: FROM pay_action_information pai_ele

579: ,pay_v.action_context_id arch_assact
580: ,pay_v.narrative ded_element
581: ,pay_v.numeric_value ded_value
582: ,pai_ele.action_information7
583: FROM pay_action_information pai_ele
584: ,pay_emea_paymnts_action_info_v pay_v
585: ,pay_assignment_actions paa
586: WHERE paa.assignment_action_id= l_assact_id
587: AND paa.payroll_action_id = pai_ele.action_context_id

Line 604: pay_action_information pai,

600: pay_action_interlocks lck,
601: pay_assignment_actions paa1,
602: pay_assignment_actions paa2,
603: pay_payroll_actions ppa,
604: pay_action_information pai,
605: pay_emea_payment_values_v pet
606: WHERE
607: lck.locked_action_id = paa1.assignment_action_id AND
608: paa1.source_action_id IS NULL AND

Line 652: FROM pay_action_information pai_ele

648: ORDER BY status, pay_amount;
649: /* Cursor to get the sum of the Earnings for particular payroll for summary */
650: /*CURSOR csr_get_sum_earn_summary (l_org_name varchar2 , l_payroll_id number , l_effective_date date) IS
651: SELECT sum(pay_v.numeric_value)
652: FROM pay_action_information pai_ele
653: ,pay_emea_paymnts_action_info_v pay_v
654: ,pay_assignment_actions paa
655: WHERE paa.payroll_action_id = pai_ele.action_context_id
656: AND pai_ele.action_context_type = 'PA'

Line 664: ,pay_action_information pai_emp

660: AND pay_v.narrative = pai_ele.action_information4
661: AND pay_v.payment_type NOT IN ('F')
662: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
663: FROM per_time_periods ptp
664: ,pay_action_information pai_emp
665: ,pay_assignment_actions paa1
666: ,pay_action_interlocks lck
667: ,pay_payroll_actions ppa1
668: WHERE ptp.payroll_id = l_payroll_id

Line 683: FROM pay_action_information pai_ele

679: AND ptp.end_date = l_effective_date);*/
680: CURSOR csr_get_sum_earn (l_org_structure_version_id number,
681: l_organization_id number , l_payroll_id number , l_effective_date date) IS
682: SELECT sum(pay_v.numeric_value)
683: FROM pay_action_information pai_ele
684: ,pay_emea_paymnts_action_info_v pay_v
685: ,pay_assignment_actions paa
686: WHERE paa.payroll_action_id = pai_ele.action_context_id
687: AND pai_ele.action_context_type = 'PA'

Line 695: ,pay_action_information pai_emp

691: AND pay_v.narrative = pai_ele.action_information4
692: AND pay_v.payment_type NOT IN ('F')
693: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
694: FROM per_time_periods ptp
695: ,pay_action_information pai_emp
696: ,pay_assignment_actions paa1
697: ,pay_action_interlocks lck
698: ,pay_payroll_actions ppa1
699: WHERE ptp.payroll_id = l_payroll_id

Line 729: ,pay_action_information pai_ele

725: ,per_time_periods ptp
726: ,pay_assignment_actions paa1
727: ,pay_action_interlocks lck
728: ,pay_payroll_actions ppa1
729: ,pay_action_information pai_ele
730: ,pay_action_information pai_emp
731: ,pay_emea_paymnts_action_info_v pay_v
732: WHERE paa.payroll_action_id = pai_ele.action_context_id
733: AND pai_ele.action_context_type = 'PA'

Line 730: ,pay_action_information pai_emp

726: ,pay_assignment_actions paa1
727: ,pay_action_interlocks lck
728: ,pay_payroll_actions ppa1
729: ,pay_action_information pai_ele
730: ,pay_action_information pai_emp
731: ,pay_emea_paymnts_action_info_v pay_v
732: WHERE paa.payroll_action_id = pai_ele.action_context_id
733: AND pai_ele.action_context_type = 'PA'
734: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'

Line 759: ,pay_action_information pai_emp

755:
756: CURSOR csr_seoo_split_1 (l_organization_id number , l_payroll_id number , l_effective_date date) IS
757: select pai_emp.action_context_id arch_assact
758: from per_time_periods ptp
759: ,pay_action_information pai_emp
760: ,pay_assignment_actions paa1
761: ,pay_action_interlocks lck
762: ,pay_payroll_actions ppa1
763: where ptp.payroll_id = l_payroll_id

Line 779: from pay_action_information pai_ele

775: and paa1.action_status IN ('C','S')
776: and ptp.end_date = l_effective_date;
777: CURSOR csr_seoo_split_2 (l_arch_assact number) IS
778: select SUM(pay_v.numeric_value)
779: from pay_action_information pai_ele
780: ,pay_emea_paymnts_action_info_v pay_v
781: ,pay_assignment_actions paa
782: where paa.payroll_action_id = pai_ele.action_context_id
783: and pai_ele.action_context_type = 'PA'

Line 798: FROM pay_action_information pai_ele

794: --CURSOR csr_get_sum_ded_summary (l_org_name varchar2 , l_payroll_id number , l_effective_date date) IS
795: CURSOR csr_get_sum_ded (l_org_structure_version_id number,
796: l_organization_id number , l_payroll_id number , l_effective_date date) IS
797: SELECT sum(pay_v.numeric_value)
798: FROM pay_action_information pai_ele
799: ,pay_emea_paymnts_action_info_v pay_v
800: ,pay_assignment_actions paa
801: WHERE paa.payroll_action_id = pai_ele.action_context_id
802: AND pai_ele.action_context_type = 'PA'

Line 810: ,pay_action_information pai_emp

806: AND pay_v.narrative = pai_ele.action_information4
807: AND pay_v.payment_type NOT IN ('F')
808: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
809: FROM per_time_periods ptp
810: ,pay_action_information pai_emp
811: ,pay_assignment_actions paa1
812: ,pay_action_interlocks lck
813: ,pay_payroll_actions ppa1
814: WHERE ptp.payroll_id = l_payroll_id

Line 844: ,pay_action_information pai_ele

840: ,per_time_periods ptp
841: ,pay_assignment_actions paa1
842: ,pay_action_interlocks lck
843: ,pay_payroll_actions ppa1
844: ,pay_action_information pai_ele
845: ,pay_action_information pai_emp
846: ,pay_emea_paymnts_action_info_v pay_v
847: WHERE paa.payroll_action_id = pai_ele.action_context_id
848: AND pai_ele.action_context_type = 'PA'

Line 845: ,pay_action_information pai_emp

841: ,pay_assignment_actions paa1
842: ,pay_action_interlocks lck
843: ,pay_payroll_actions ppa1
844: ,pay_action_information pai_ele
845: ,pay_action_information pai_emp
846: ,pay_emea_paymnts_action_info_v pay_v
847: WHERE paa.payroll_action_id = pai_ele.action_context_id
848: AND pai_ele.action_context_type = 'PA'
849: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'

Line 874: ,pay_action_information pai_emp

870:
871: CURSOR csr_sdoo_split_1 (l_organization_id number , l_payroll_id number , l_effective_date date) IS
872: select pai_emp.action_context_id arch_assact
873: from per_time_periods ptp
874: ,pay_action_information pai_emp
875: ,pay_assignment_actions paa1
876: ,pay_action_interlocks lck
877: ,pay_payroll_actions ppa1
878: where ptp.payroll_id = l_payroll_id

Line 894: from pay_action_information pai_ele

890: and paa1.action_status IN ('C','S')
891: and ptp.end_date = l_effective_date;
892: CURSOR csr_sdoo_split_2 (l_arch_assact number) IS
893: select SUM(pay_v.numeric_value)
894: from pay_action_information pai_ele
895: ,pay_emea_paymnts_action_info_v pay_v
896: ,pay_assignment_actions paa
897: where paa.payroll_action_id = pai_ele.action_context_id
898: and pai_ele.action_context_type = 'PA'