[Home] [Help]
881: if check_assignment_tax_ref(csr_rec.assignment_id,l_tax_reference,l_benefit_end_date) then
882: if l_prev_assignment_id IS NULL OR l_prev_assignment_id <> csr_rec.assignment_id
883: THEN
884: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
885: SELECT pay_assignment_actions_s.NEXTVAL
886: INTO l_actid
887: FROM DUAL;
888:
889: hr_utility.set_location('Archive assignment Action ', 30);
913: if check_assignment_tax_ref(csr_rec.assignment_id,l_tax_reference,l_benefit_end_date) then
914: if l_prev_assignment_id IS NULL OR l_prev_assignment_id <> csr_rec.assignment_id
915: THEN
916: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
917: SELECT pay_assignment_actions_s.NEXTVAL
918: INTO l_actid
919: FROM DUAL;
920:
921: hr_utility.set_location('Archive assignment Action ', 30);
946: if check_assignment_tax_ref(csr_rec.assignment_id,l_tax_reference,l_benefit_end_date) then
947: IF l_prev_assignment_id IS NULL OR l_prev_assignment_id <> csr_rec.assignment_id
948: THEN
949: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
950: SELECT pay_assignment_actions_s.NEXTVAL
951: INTO l_actid
952: FROM DUAL;
953: hr_utility.set_location('Archive assignment Action ', 30);
954: hr_nonrun_asact.insact(l_actid, csr_rec.assignment_id, pactid, CHUNK, NULL);
1025: SELECT paa.assignment_action_id, pai_person.action_information1, pai_comp.action_information6,
1026: pai_comp.action_information7
1027: FROM pay_action_information pai_comp,
1028: pay_action_information pai_person,
1029: pay_assignment_actions paa,
1030: pay_payroll_actions ppa
1031: WHERE ppa.payroll_action_id = g_pactid
1032: AND paa.payroll_action_id = ppa.payroll_action_id
1033: AND pai_comp.action_context_id = paa.assignment_action_id
1038: AND pai_person.action_information1 = p_person_id
1039: AND pai_comp.action_information6 = p_emp_ref
1040: AND pai_comp.action_information7 = p_emp_name;
1041:
1042: CURSOR csr_val_element_entry_id(v_assactid pay_assignment_actions.assignment_action_id%TYPE,
1043: v_benefit_start_date VARCHAR2,
1044: v_benefit_end_date VARCHAR2)
1045: IS
1046: SELECT DISTINCT pet.element_type_id element_type_id, peev.element_entry_id element_entry_id,
1051: pay_input_values_f piv,
1052: pay_element_entry_values_f peev,
1053: pay_element_entries_f pee,
1054: per_assignments_f paa,
1055: pay_assignment_actions paac
1056: WHERE pet.classification_id = pec.classification_id AND
1057: pet.element_type_id = piv.element_type_id AND
1058: piv.input_value_id = peev.input_value_id AND
1059: pee.element_entry_id = peev.element_entry_id AND
3728: -- 4248907 Perf fix - csr_incorrect_ni_percentage - Broken into 2 separate cursors
3729: CURSOR csr_incorrect_ni_num IS
3730: SELECT pai.action_information7 action_information7, COUNT(1) temp_num
3731: FROM pay_payroll_actions ppa,
3732: pay_assignment_actions paa,
3733: pay_action_information pai,
3734: pay_action_information pai_emp
3735: WHERE ppa.payroll_action_id = pactid
3736: AND paa.payroll_action_id = ppa.payroll_action_id
3747:
3748: CURSOR csr_total_num(p_employer_name varchar2) IS
3749: SELECT pai.action_information7 action_information7, COUNT(1) tot_num
3750: FROM pay_payroll_actions ppa,
3751: pay_assignment_actions paa,
3752: pay_action_information pai
3753: WHERE ppa.payroll_action_id = pactid
3754: AND paa.payroll_action_id = ppa.payroll_action_id
3755: AND pai.action_context_id = paa.assignment_action_id
3761: CURSOR csr_expenses_payment_chk
3762: IS
3763: SELECT COUNT(DISTINCT pai_ben.action_information10)
3764: FROM pay_payroll_actions ppa,
3765: pay_assignment_actions paa,
3766: pay_action_information pai_ben
3767: WHERE ppa.payroll_action_id = pactid
3768: AND ppa.payroll_action_id = paa .payroll_action_id
3769: AND pai_ben.action_context_id = paa.assignment_action_id
3790: -- 'EXPENSES PAYMENTS', pai.action_information8,
3791: '0') ) p11db_value
3792: FROM pay_action_information pai_comp,
3793: pay_action_information pai,
3794: pay_assignment_actions paa,
3795: pay_payroll_actions ppa
3796: WHERE ppa.payroll_action_id = pactid
3797: AND ppa.payroll_action_id = paa .payroll_action_id
3798: AND pai_comp.action_context_id = paa.assignment_action_id
3824: ppa.action_information9,
3825: ppa.action_information10,
3826: ppa.action_information11,
3827: ppa.action_information12
3828: from pay_assignment_actions paa,
3829: pay_action_information ppa
3830: where paa.payroll_action_id = pactid
3831: and paa.assignment_action_id = ppa.action_context_id
3832: and ppa.action_information_category = 'GB EMPLOYEE DETAILS'
3920: PROCEDURE write_summary(p_pact_id number) IS
3921:
3922: cursor get_employer(p_pact_id number) is
3923: select action_information7
3924: from pay_assignment_actions paa,
3925: pay_action_information pai
3926: where paa.payroll_action_id = p_pact_id
3927: and pai.action_context_id = paa.assignment_action_id
3928: and pai.action_information_category = 'EMEA PAYROLL INFO'
3972: 'OTHER ITEMS', 'M',
3973: 'OTHER ITEMS NON 1A', 'M',
3974: 'EXPENSES PAYMENTS', 'N') cat,
3975: count(*) no_of_entries
3976: from pay_assignment_actions paa,
3977: pay_action_information pai,
3978: pay_action_information pai_a,
3979: pay_action_information pai_person
3980: where paa.payroll_action_id = p_pact_id
3996: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
3997: use_index(pai_person,pay_action_information_n2)
3998: use_index(pai,pay_action_information_n2) */
3999: sum(pai.action_information12)
4000: from pay_assignment_actions paa,
4001: pay_action_information pai,
4002: pay_action_information pai_person
4003: where paa.payroll_action_id = p_pact_id
4004: and pai.action_context_id = paa.assignment_action_id
4013: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
4014: use_index(pai_person,pay_action_information_n2)
4015: use_index(pai,pay_action_information_n2) */
4016: sum(pai.action_information11) -- Cash Equivalent For Fuel
4017: from pay_assignment_actions paa,
4018: pay_action_information pai,
4019: pay_action_information pai_person
4020: where paa.payroll_action_id = p_pact_id
4021: and pai.action_context_id = paa.assignment_action_id
4030: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
4031: use_index(pai_person,pay_action_information_n2)
4032: use_index(pai,pay_action_information_n2) */
4033: sum(pai.action_information30) -- Cash Equivalent For Fuel
4034: from pay_assignment_actions paa,
4035: pay_action_information pai,
4036: pay_action_information pai_person
4037: where paa.payroll_action_id = p_pact_id
4038: and pai.action_context_id = paa.assignment_action_id
4050: from (select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
4051: use_index(pai_person,pay_action_information_n2)
4052: use_index(pai,pay_action_information_n2) */
4053: pai_person.action_information10 -- Person id
4054: from pay_assignment_actions paa,
4055: pay_action_information pai,
4056: pay_action_information pai_person
4057: where paa.payroll_action_id = p_pact_id
4058: and pai.action_context_id = paa.assignment_action_id
4207: substr(pml.line_text,instr(pml.line_text,':') + 2) line_text,
4208: substr(pml.line_text,6,instr(pml.line_text,':') - 6) element_name,
4209: pml.line_sequence
4210: from pay_payroll_actions pay,
4211: pay_assignment_actions paa,
4212: per_all_assignments_f paf,
4213: per_all_people_f pap,
4214: per_periods_of_service pos,
4215: pay_message_lines pml