[Home] [Help]
15: report_category pay_payroll_actions.report_category%TYPE,
16: business_group_id NUMBER,
17: effective_date date,
18: -- Bug 3506172
19: bp_np_number hr_organization_information.org_information1%type);
20: -- End of 3506172
21: g_pact t_pact;
22: --------------------------------------------------------------------------------+
23: -- Range cursor returns the ids of the assignments to be archived
100: ------------------------------------------------------------------------------
101: -- Cursor altered for fix 2928733
102: -- Added distinct to the SELECT clause
103: ------------------------------------------------------------------------------
104: CURSOR csr_asg(p_bp_np_number hr_organization_information.org_information1%type
105: ,p_start_date in date
106: ,p_end_date in date)
107: IS
108: SELECT distinct ass.assignment_id
108: SELECT distinct ass.assignment_id
109: ,ass.establishment_id
110: FROM pay_payroll_actions bppa
111: ,per_assignments_f ass
112: ,hr_organization_information hoi
113: ,hr_organization_units hou
114: WHERE bppa.payroll_action_id = p_payroll_action_id
115: AND ass.person_id BETWEEN p_start_person_id AND p_end_person_id
116: -- Bug 3506172
284: ,hoi1.org_information14 computerization_code
285: FROM pay_assignment_actions paa
286: ,per_assignments_f ass
287: ,per_people_f pp
288: ,hr_organization_information hoi
289: ,hr_organization_information hoi1
290: WHERE paa.assignment_action_id = p_assignment_action_id
291: AND paa.assignment_id = ass.assignment_id
292: AND ass.person_id = pp.person_id
285: FROM pay_assignment_actions paa
286: ,per_assignments_f ass
287: ,per_people_f pp
288: ,hr_organization_information hoi
289: ,hr_organization_information hoi1
290: WHERE paa.assignment_action_id = p_assignment_action_id
291: AND paa.assignment_id = ass.assignment_id
292: AND ass.person_id = pp.person_id
293: AND ass.establishment_id = hoi.organization_id