[Home] [Help]
53: cursor csr_count_taxref(p_pact_id number)
54: is
55: select count(*),
56: action_information6
57: from pay_assignment_actions paa,
58: pay_action_information pai
59: where paa.payroll_action_id = p_pact_id
60: and pai.action_context_id = paa.assignment_action_id
61: and pai.action_information_category = 'EMEA PAYROLL INFO'
182: select /*+ ordered
183: use_nl(paa,pai_person)
184: use_index(pai_person,pay_action_information_n2) */
185: distinct paa.assignment_id
186: from pay_assignment_actions paa,
187: pay_action_information pai_person,
188: pay_action_information pai_emp
189: where paa.payroll_action_id = v_archive_payroll_action_id
190: and pai_person.action_context_id = paa.assignment_action_id
200: pai_emp.action_information6 = v_tax_ref)
201: order by paa.assignment_id;
202:
203: --
204: l_ass_act_id pay_assignment_actions.assignment_action_id%TYPE;
205: l_proc CONSTANT VARCHAR2(35) := g_package || 'action_creation';
206: l_arch_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
207: l_tax_ref varchar2(30);
208: BEGIN
219: LOOP
220: --
221: -- Create the assignment_action to represent the preson / tax unit combination
222: --
223: SELECT pay_assignment_actions_s.nextval
224: INTO l_ass_act_id
225: FROM dual;
226: --
227: -- insert into pay_assignment_actions.
223: SELECT pay_assignment_actions_s.nextval
224: INTO l_ass_act_id
225: FROM dual;
226: --
227: -- insert into pay_assignment_actions.
228: hr_utility.set_location ('assignment id ' || asgrec.assignment_id, 1);
229:
230: hr_nonrun_asact.insact (l_ass_act_id, asgrec.assignment_id, pactid, chunk, NULL);
231: