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 165: ,pay_assignment_actions paa1

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
169: WHERE ptp.payroll_id = l_payroll_id

Line 188: ,pay_assignment_actions paa1

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
192: AND ptp.time_period_id = pai_emp.action_information16

Line 211: ,pay_assignment_actions paa1

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
215: WHERE ptp.time_period_id = pai_emp.action_information16

Line 244: ,pay_assignment_actions paa1

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

Line 277: ,pay_assignment_actions paa1

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
281: WHERE ptp.time_period_id = pai_emp.action_information16

Line 299: ,pay_assignment_actions paa1

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

Line 322: ,pay_assignment_actions paa1

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
326: WHERE ptp.time_period_id = pai_emp.action_information16

Line 350: ,pay_assignment_actions paa1

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
354: WHERE ptp.time_period_id = pai_emp.action_information16

Line 382: ,pay_assignment_actions paa1

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

Line 414: ,pay_assignment_actions paa1

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
418: WHERE ptp.time_period_id = pai_emp.action_information16

Line 462: ,pay_assignment_actions paa1

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
466: WHERE ptp.payroll_id = l_payroll_id

Line 506: ,pay_assignment_actions paa1

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
510: AND ptp.time_period_id = pai_emp.action_information16

Line 539: ,pay_assignment_actions paa

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

Line 555: pay_assignment_actions paa1,

551: ,pet.result_value earn_value
552: ,pai.action_information7
553: FROM
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

Line 556: pay_assignment_actions paa2,

552: ,pai.action_information7
553: FROM
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

Line 585: ,pay_assignment_actions paa

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

Line 601: pay_assignment_actions paa1,

597: ,pet.result_value ded_value
598: ,pai.action_information7
599: FROM
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

Line 602: pay_assignment_actions paa2,

598: ,pai.action_information7
599: FROM
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

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

629: ,pen.segment2 branch_name
630: ,pen.segment4 account_number
631: ,pen.value pay_amount
632: ,pen.action_context_id
633: ,pay_assignment_actions_pkg.get_payment_status(paa.assignment_action_id,ppp.pre_payment_id) status
634: FROM pay_emp_net_dist_action_info_v pen
635: ,pay_action_interlocks pai
636: ,pay_assignment_actions paa
637: ,pay_payroll_actions ppa

Line 636: ,pay_assignment_actions paa

632: ,pen.action_context_id
633: ,pay_assignment_actions_pkg.get_payment_status(paa.assignment_action_id,ppp.pre_payment_id) status
634: FROM pay_emp_net_dist_action_info_v pen
635: ,pay_action_interlocks pai
636: ,pay_assignment_actions paa
637: ,pay_payroll_actions ppa
638: ,pay_pre_payments ppp
639: WHERE pen.action_context_id = l_assact_id
640: AND pen.action_context_id = pai.locking_action_id

Line 654: ,pay_assignment_actions paa

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'
657: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'
658: AND pai_ele.action_information7 IN ('E')

Line 665: ,pay_assignment_actions paa1

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
669: AND ptp.time_period_id = pai_emp.action_information16

Line 685: ,pay_assignment_actions paa

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'
688: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'
689: AND pai_ele.action_information7 IN ('E')

Line 696: ,pay_assignment_actions paa1

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
700: AND ptp.time_period_id = pai_emp.action_information16

Line 724: FROM pay_assignment_actions paa

720: /****Cursor split into 2 for fixing performance bug
721: CURSOR csr_get_sum_earn_only_org (l_organization_id number , l_payroll_id number , l_effective_date date) IS
722: --*******Fixed during performance bugs*****
723: SELECT sum(pay_v.numeric_value)
724: FROM pay_assignment_actions paa
725: ,per_time_periods ptp
726: ,pay_assignment_actions paa1
727: ,pay_action_interlocks lck
728: ,pay_payroll_actions ppa1

Line 726: ,pay_assignment_actions paa1

722: --*******Fixed during performance bugs*****
723: SELECT sum(pay_v.numeric_value)
724: FROM pay_assignment_actions paa
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

Line 760: ,pay_assignment_actions paa1

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
764: and ptp.time_period_id = pai_emp.action_information16

Line 781: ,pay_assignment_actions paa

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'
784: and pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'
785: and pai_ele.action_information7 in ('E')

Line 800: ,pay_assignment_actions paa

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'
803: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'
804: AND pai_ele.action_information7 IN ('D')

Line 811: ,pay_assignment_actions paa1

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
815: AND ptp.time_period_id = pai_emp.action_information16

Line 839: FROM pay_assignment_actions paa

835: /****Cursor split into 2 for fixing performance bug
836: CURSOR csr_get_sum_ded_only_org (l_organization_id number , l_payroll_id number , l_effective_date date) IS
837: --******* Fixed during performance bugs*******
838: SELECT sum(pay_v.numeric_value)
839: FROM pay_assignment_actions paa
840: ,per_time_periods ptp
841: ,pay_assignment_actions paa1
842: ,pay_action_interlocks lck
843: ,pay_payroll_actions ppa1

Line 841: ,pay_assignment_actions paa1

837: --******* Fixed during performance bugs*******
838: SELECT sum(pay_v.numeric_value)
839: FROM pay_assignment_actions paa
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

Line 875: ,pay_assignment_actions paa1

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
879: and ptp.time_period_id = pai_emp.action_information16

Line 896: ,pay_assignment_actions paa

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'
899: and pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'
900: and pai_ele.action_information7 in ('D')