[Home] [Help]
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pay_process_events ppe
30: , per_all_assignments_f paa
31: where ppe.process_event_id = p_process_event_id
32: and ppe.assignment_id = paa.assignment_id
33: and pbg.business_group_id = paa.business_group_id
34: and ppe.effective_date between paa.effective_start_date
90: cursor csr_leg_code is
91: select pbg.legislation_code
92: from per_business_groups pbg
93: , pay_process_events ppe
94: , per_all_assignments_f paa
95: where ppe.process_event_id = p_process_event_id
96: and ppe.assignment_id = paa.assignment_id
97: and pbg.business_group_id = paa.business_group_id
98: and ppe.effective_date between paa.effective_start_date
298: -- {Start Of Comments}
299: --
300: -- Description:
301: -- This procedure is used to ensure that the assignment_id exists in
302: -- PER_ALL_ASSIGNMENTS_F for the given effective date
303: --
304: -- Pre Conditions:
305: -- Must have effective date
306: --
329: cursor csr_assignment_exists is
330: select 'x'
331: from dual
332: where exists (select 1
333: from per_all_assignments_f paa
334: where p_rec.assignment_id = paa.assignment_id
335: and p_rec.effective_date between paa.effective_start_date
336: and paa.effective_end_date);
337: --