[Home] [Help]
29: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
30: p_start_person_id in per_all_people_f.person_id%type,
31: p_end_person_id in per_all_people_f.person_id%type,
32: p_chunk in number) is
33: v_next_action_id pay_assignment_actions.assignment_action_id%type;
34: cursor process_assignments
35: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
36: c_start_person_id in per_all_people_f.person_id%type,
37: c_end_person_id in per_all_people_f.person_id%type) is
41: from per_assignments_f a,
42: per_people_f p,
43: pay_payroll_actions pa,
44: pay_payroll_actions ppa,
45: pay_assignment_actions ppac
46: where pa.payroll_action_id = c_payroll_action_id
47: and p.person_id between c_start_person_id and c_end_person_id
48: and p.person_id = a.person_id
49: and p.business_group_id = pa.business_group_id
53: And ppa.action_type = 'X'
54: and ppa.action_status = 'C'
55: and ppac.assignment_action_id in
56: (select max(ppac1.assignment_action_id)
57: from pay_assignment_actions ppac1,
58: pay_payroll_Actions ppaa
59: where ppaa.action_type ='X'
60: and ppaa.action_status ='C'
61: and ppaa.report_type ='KW_PIFSS_REPORT'
65: (select locked_action_id
66: FROM pay_action_interlocks pail
67: WHERE pail.locked_action_id=ppac.assignment_action_id);
68: cursor next_action_id is
69: select pay_assignment_actions_s.nextval
70: from dual;
71: begin
72: hr_utility.set_location('Start of assignment_action_code',3);
73: hr_utility.set_location('The payroll_action_id passed '|| p_payroll_action_id,4);