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 896: pay_assignment_actions paa,

892: Cursor csr_result_value ( p_assignment_id IN NUMBER,
893: p_element_name IN VARCHAR2,
894: p_input_val_name IN VARCHAR2) IS
895: SELECT prrv.result_value FROM
896: pay_assignment_actions paa,
897: pay_run_results prr,
898: pay_element_types_f petf,
899: pay_input_values_f pivf,
900: pay_run_result_values prrv

Line 911: pay_assignment_actions paa,

907: AND pivf.name = p_input_val_name
908: AND prrv.input_value_id = pivf.input_value_id
909: AND prrv.run_result_id = prr.run_result_id
910: AND paa.action_sequence = (SELECT MAX(paa.action_sequence) FROM
911: pay_assignment_actions paa,
912: pay_run_results prr,
913: pay_element_types_f
914: WHERE paa.assignment_id = p_assignment_id
915: AND paa.assignment_action_id = prr.assignment_action_id

Line 3107: FROM pay_action_information pai , pay_assignment_actions paa

3103: CURSOR csr_arch_fi (p_payroll_action_id NUMBER) IS
3104: SELECT substr(action_information4,1,1) payment_type , SUM(nvl(action_information9,0)) payment , SUM(nvl(action_information10,0)) tax , COUNT(*) num
3105: ,SUM(nvl(action_information12,0)) pretax_ded, SUM(nvl(action_information11,0)) pen_unemp_ins , SUM(nvl(action_information25,0)) bik
3106: , SUM(nvl(action_information27,0) + nvl(action_information23,0)) CODE_670 ,SUM(nvl(action_information28,0)) CODE_631
3107: FROM pay_action_information pai , pay_assignment_actions paa
3108: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
3109: AND pai.action_context_type= 'AAP'
3110: AND pai.action_context_id= paa.assignment_action_id
3111: AND paa.payroll_action_id = p_payroll_action_id

Line 3122: FROM pay_action_information pai , pay_assignment_actions paa

3118: CURSOR csr_arch_fi_p2 (p_payroll_action_id NUMBER) IS
3119: SELECT substr(action_information4,1,1) payment_type , SUM(nvl(action_information9,0)) payment , SUM(nvl(action_information10,0)) tax , COUNT(*) num
3120: ,SUM(nvl(action_information12,0)) pretax_ded, SUM(nvl(action_information11,0)) pen_unemp_ins , SUM(nvl(action_information25,0)) bik
3121: , SUM(nvl(action_information27,0) + nvl(action_information23,0)) CODE_670 ,SUM(nvl(action_information28,0)) CODE_631
3122: FROM pay_action_information pai , pay_assignment_actions paa
3123: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
3124: AND pai.action_context_type= 'AAP'
3125: AND pai.action_context_id= paa.assignment_action_id
3126: AND paa.payroll_action_id = p_payroll_action_id

Line 3140: FROM pay_action_information pai , pay_assignment_actions paa

3136: /* Cursor to fetch data related to Foreign Residents Social Security Not Liable*/
3137: CURSOR csr_arch_fr_nss ( p_payroll_action_id NUMBER) IS
3138: SELECT SUM(nvl(action_information15,0)) payment, SUM(nvl(action_information16,0)) tax , COUNT(*) num,
3139: SUM(nvl(action_information19,0)) pretax_ded, SUM(nvl(action_information18,0)) bik
3140: FROM pay_action_information pai , pay_assignment_actions paa
3141: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
3142: AND pai.action_context_type= 'AAP'
3143: AND pai.action_context_id= paa.assignment_action_id
3144: AND paa.payroll_action_id = p_payroll_action_id

Line 3154: FROM pay_action_information pai , pay_assignment_actions paa

3150: /* Cursor to fetch data related to Foreign Residents Social Security liable*/
3151: CURSOR csr_arch_fr_ss ( p_payroll_action_id NUMBER) IS
3152: SELECT SUM(nvl(action_information15,0)) payment, SUM(nvl(action_information16,0)) tax , COUNT(*) num,
3153: SUM(nvl(action_information19,0)) pretax_ded, SUM(nvl(action_information18,0)) bik
3154: FROM pay_action_information pai , pay_assignment_actions paa
3155: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
3156: AND pai.action_context_type= 'AAP'
3157: AND pai.action_context_id= paa.assignment_action_id
3158: AND paa.payroll_action_id = p_payroll_action_id

Line 3166: FROM pay_action_information pai , pay_assignment_actions paa

3162:
3163: /* Cursor to fetch data related to Record VSPSERIE*/
3164: CURSOR csr_VSPSERIE (p_payroll_action_id NUMBER) IS
3165: SELECT pai.action_information30
3166: FROM pay_action_information pai , pay_assignment_actions paa
3167: WHERE paa.payroll_action_id = p_payroll_action_id
3168: AND pai.action_context_id= paa.assignment_action_id
3169: AND pai.action_context_type= 'AAP'
3170: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 3180: FROM pay_action_information pai , pay_assignment_actions paa

3176:
3177: /* Cursor to fetch data related to Record VSRAERIE*/
3178: CURSOR csr_VSRAERIE(p_payroll_action_id NUMBER) IS
3179: SELECT pai.action_information30
3180: FROM pay_action_information pai , pay_assignment_actions paa
3181: WHERE paa.payroll_action_id = p_payroll_action_id
3182: AND pai.action_context_id= paa.assignment_action_id
3183: AND pai.action_context_type= 'AAP'
3184: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 3220: FROM pay_action_information pai , pay_assignment_actions paa

3216:
3217: /* Cursor to fetch data related to Record VSPSTUKI*/
3218: CURSOR csr_VSPSTUKI(p_payroll_action_id NUMBER) IS
3219: SELECT pai.action_information30
3220: FROM pay_action_information pai , pay_assignment_actions paa
3221: WHERE paa.payroll_action_id = p_payroll_action_id
3222: AND pai.action_context_id= paa.assignment_action_id
3223: AND pai.action_context_type= 'AAP'
3224: AND pai.action_information_category = 'EMEA REPORT INFORMATION'