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_FI_ARCHIVE_DPSA dependencies on PAY_ASSIGNMENT_ACTIONS

Line 479: ,pay_assignment_actions act

475: act1.assignment_action_id prepaid_action_id
476: FROM pay_payroll_actions ppa
477: ,pay_payroll_actions appa
478: ,pay_payroll_actions appa2
479: ,pay_assignment_actions act
480: ,pay_assignment_actions act1
481: ,pay_action_interlocks pai
482: ,per_all_assignments_f as1
483: ,hr_soft_coding_keyflex hsck

Line 480: ,pay_assignment_actions act1

476: FROM pay_payroll_actions ppa
477: ,pay_payroll_actions appa
478: ,pay_payroll_actions appa2
479: ,pay_assignment_actions act
480: ,pay_assignment_actions act1
481: ,pay_action_interlocks pai
482: ,per_all_assignments_f as1
483: ,hr_soft_coding_keyflex hsck
484: ,pay_run_result_values TARGET

Line 515: from pay_assignment_actions act2

511: AND act.TAX_UNIT_ID = p_legal_employer_id
512: and TARGET.run_result_id = RR.run_result_id
513: AND (( RR.assignment_action_id
514: in ( Select act2.assignment_action_id
515: from pay_assignment_actions act2
516: Where act2.source_action_id=act.assignment_action_id
517: AND act2.action_status = 'C' -- Completed
518: AND act2.payroll_action_id = act.payroll_action_id))
519: or

Line 539: ,pay_assignment_actions act

535: act1.assignment_action_id prepaid_action_id
536: FROM pay_payroll_actions ppa
537: ,pay_payroll_actions appa
538: ,pay_payroll_actions appa2
539: ,pay_assignment_actions act
540: ,pay_assignment_actions act1
541: ,pay_action_interlocks pai
542: ,per_all_assignments_f as1
543: ,pay_run_result_values TARGET

Line 540: ,pay_assignment_actions act1

536: FROM pay_payroll_actions ppa
537: ,pay_payroll_actions appa
538: ,pay_payroll_actions appa2
539: ,pay_assignment_actions act
540: ,pay_assignment_actions act1
541: ,pay_action_interlocks pai
542: ,per_all_assignments_f as1
543: ,pay_run_result_values TARGET
544: ,pay_run_results RR

Line 572: from pay_assignment_actions act2

568: AND act.TAX_UNIT_ID = p_legal_employer_id
569: and TARGET.run_result_id = RR.run_result_id
570: AND (( RR.assignment_action_id
571: in ( Select act2.assignment_action_id
572: from pay_assignment_actions act2
573: Where act2.source_action_id=act.assignment_action_id
574: AND act2.action_status = 'C' -- Completed
575: AND act2.payroll_action_id = act.payroll_action_id))
576: or

Line 630: SELECT pay_assignment_actions_s.NEXTVAL

626: LOOP
627: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id
628: AND l_prev_person_id <> rec_prepaid_assignments.person_id THEN
629:
630: SELECT pay_assignment_actions_s.NEXTVAL
631: INTO l_actid
632: FROM dual;
633:
634: -- Create the archive assignment action

Line 663: SELECT pay_assignment_actions_s.NEXTVAL

659: LOOP
660: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id
661: AND l_prev_person_id <> rec_prepaid_assignments.person_id THEN
662:
663: SELECT pay_assignment_actions_s.NEXTVAL
664: INTO l_actid
665: FROM dual;
666:
667: -- Create the archive assignment action

Line 727: ,pay_assignment_actions pac

723: ,p_end_date DATE
724: ,p_business_group_id NUMBER) IS
725: SELECT MAX( EFFECTIVE_END_DATE) EFFECTIVE_END_DATE
726: FROM per_all_assignments paa
727: ,pay_assignment_actions pac
728: WHERE pac.assignment_action_id = p_asg_act_id
729: AND paa.assignment_id = pac.assignment_id
730: AND paa.EFFECTIVE_START_DATE <= p_end_date
731: AND paa.EFFECTIVE_END_DATE > = p_start_date

Line 748: pay_assignment_actions pac,

744: CURSOR csr_get_person_details(p_asg_act_id NUMBER , p_asg_effective_date DATE ) IS
745: SELECT pap.first_name first_name , pap.last_name last_name , pap. national_identifier , pap. person_id , pac.assignment_id,
746: pap.per_information1 place_residence , pap.business_group_id , pap.per_information23 fpin
747: FROM
748: pay_assignment_actions pac,
749: per_all_assignments_f assign,
750: per_all_people_f pap
751: WHERE pac.assignment_action_id = p_asg_act_id
752: AND assign.assignment_id = pac.assignment_id

Line 810: FROM pay_action_information pai , pay_assignment_actions paa

806: CURSOR csr_rpt_header (p_asg_act_id NUMBER) IS
807: SELECT action_context_id payroll_action_id ,action_information2 emp_type ,action_information3 emp_id
808: ,action_information4 business_id ,action_information5 org_type ,action_information6 contact_person
809: ,action_information7 phone ,action_information8 year ,action_information9 transact_type
810: FROM pay_action_information pai , pay_assignment_actions paa
811: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
812: AND pai.action_information1 = 'PYFIDPSA'
813: AND pai.action_context_id = paa.payroll_action_id
814: AND paa.assignment_action_id = p_asg_act_id;

Line 2968: FROM pay_action_information pai , pay_assignment_actions paa

2964: CURSOR csr_arch_fi (p_payroll_action_id NUMBER) IS
2965: SELECT substr(action_information4,1,1) payment_type , SUM(nvl(action_information9,0)) payment , SUM(nvl(action_information10,0)) tax , COUNT(*) num
2966: ,SUM(nvl(action_information12,0)) pretax_ded, SUM(nvl(action_information11,0)) pen_unemp_ins , SUM(nvl(action_information25,0)) bik
2967: , SUM(nvl(action_information27,0) + nvl(action_information23,0)) CODE_670 ,SUM(nvl(action_information28,0)) CODE_631
2968: FROM pay_action_information pai , pay_assignment_actions paa
2969: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
2970: AND pai.action_context_type= 'AAP'
2971: AND pai.action_context_id= paa.assignment_action_id
2972: AND paa.payroll_action_id = p_payroll_action_id

Line 2983: FROM pay_action_information pai , pay_assignment_actions paa

2979: CURSOR csr_arch_fi_p2 (p_payroll_action_id NUMBER) IS
2980: SELECT substr(action_information4,1,1) payment_type , SUM(nvl(action_information9,0)) payment , SUM(nvl(action_information10,0)) tax , COUNT(*) num
2981: ,SUM(nvl(action_information12,0)) pretax_ded, SUM(nvl(action_information11,0)) pen_unemp_ins , SUM(nvl(action_information25,0)) bik
2982: , SUM(nvl(action_information27,0) + nvl(action_information23,0)) CODE_670 ,SUM(nvl(action_information28,0)) CODE_631
2983: FROM pay_action_information pai , pay_assignment_actions paa
2984: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
2985: AND pai.action_context_type= 'AAP'
2986: AND pai.action_context_id= paa.assignment_action_id
2987: AND paa.payroll_action_id = p_payroll_action_id

Line 3001: FROM pay_action_information pai , pay_assignment_actions paa

2997: /* Cursor to fetch data related to Foreign Residents Social Security Not Liable*/
2998: CURSOR csr_arch_fr_nss ( p_payroll_action_id NUMBER) IS
2999: SELECT SUM(nvl(action_information15,0)) payment, SUM(nvl(action_information16,0)) tax , COUNT(*) num,
3000: SUM(nvl(action_information19,0)) pretax_ded, SUM(nvl(action_information18,0)) bik
3001: FROM pay_action_information pai , pay_assignment_actions paa
3002: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
3003: AND pai.action_context_type= 'AAP'
3004: AND pai.action_context_id= paa.assignment_action_id
3005: AND paa.payroll_action_id = p_payroll_action_id

Line 3015: FROM pay_action_information pai , pay_assignment_actions paa

3011: /* Cursor to fetch data related to Foreign Residents Social Security liable*/
3012: CURSOR csr_arch_fr_ss ( p_payroll_action_id NUMBER) IS
3013: SELECT SUM(nvl(action_information15,0)) payment, SUM(nvl(action_information16,0)) tax , COUNT(*) num,
3014: SUM(nvl(action_information19,0)) pretax_ded, SUM(nvl(action_information18,0)) bik
3015: FROM pay_action_information pai , pay_assignment_actions paa
3016: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
3017: AND pai.action_context_type= 'AAP'
3018: AND pai.action_context_id= paa.assignment_action_id
3019: AND paa.payroll_action_id = p_payroll_action_id

Line 3027: FROM pay_action_information pai , pay_assignment_actions paa

3023:
3024: /* Cursor to fetch data related to Record VSPSERIE*/
3025: CURSOR csr_VSPSERIE (p_payroll_action_id NUMBER) IS
3026: SELECT pai.action_information30
3027: FROM pay_action_information pai , pay_assignment_actions paa
3028: WHERE paa.payroll_action_id = p_payroll_action_id
3029: AND pai.action_context_id= paa.assignment_action_id
3030: AND pai.action_context_type= 'AAP'
3031: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 3041: FROM pay_action_information pai , pay_assignment_actions paa

3037:
3038: /* Cursor to fetch data related to Record VSRAERIE*/
3039: CURSOR csr_VSRAERIE(p_payroll_action_id NUMBER) IS
3040: SELECT pai.action_information30
3041: FROM pay_action_information pai , pay_assignment_actions paa
3042: WHERE paa.payroll_action_id = p_payroll_action_id
3043: AND pai.action_context_id= paa.assignment_action_id
3044: AND pai.action_context_type= 'AAP'
3045: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 3081: FROM pay_action_information pai , pay_assignment_actions paa

3077:
3078: /* Cursor to fetch data related to Record VSPSTUKI*/
3079: CURSOR csr_VSPSTUKI(p_payroll_action_id NUMBER) IS
3080: SELECT pai.action_information30
3081: FROM pay_action_information pai , pay_assignment_actions paa
3082: WHERE paa.payroll_action_id = p_payroll_action_id
3083: AND pai.action_context_id= paa.assignment_action_id
3084: AND pai.action_context_type= 'AAP'
3085: AND pai.action_information_category = 'EMEA REPORT INFORMATION'