[Home] [Help]
16: IS
17: Cursor csr_identifier IS
18: Select null
19: from per_all_assignments_f asg,
20: hr_soft_coding_keyflex scl
21: where asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
22: and scl.segment23 = p_identifier;
23: -- As in Update Case Never Identifier is gonna change and we are not supporting
24: -- Any PUI Updates we need't have to check the assignment_id <> current_assignment_id
85: l_proc varchar2(30);
86: Cursor csr_tot_percent_effected Is
87: Select Sum(nvl(scl.segment25,0)) Percenteffected
88: From per_all_assignments_f assign,
89: hr_soft_coding_keyflex scl
90: Where person_id = p_person_id
91: And assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
92: And assign.primary_flag = 'N'
93: And p_effective_date Between effective_start_date And effective_end_date
95:
96: Cursor csr_asg_percent_effected Is
97: Select nvl(scl.segment25,0) Percenteffected
98: From per_all_assignments_f assign,
99: hr_soft_coding_keyflex scl
100: Where person_id = p_person_id
101: And assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
102: And assign.primary_flag = 'N'
103: And p_effective_date Between effective_start_date And effective_end_date
233: -- Cursor to check if there exist any primary affectation at the effective date
234:
235: Cursor is_primary_eff_exist_csr IS
236: Select null
237: from per_all_assignments_f asg, hr_soft_coding_keyflex scl
238: where segment26 = p_admin_career_id
239: and segment27 ='Y'
240: and asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
241: and p_effective_date between asg.effective_start_date and asg.effective_end_date
244: -- Cursor to check if there exist any primary affectation at any future date
245:
246: Cursor is_fut_primary_eff_exist_csr IS
247: Select effective_start_date
248: from per_all_assignments_f asg, hr_soft_coding_keyflex scl
249: where segment26 = p_admin_career_id
250: and segment27 ='Y'
251: and asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
252: and asg.effective_start_date > p_effective_date;