APPS.PQH_FR_ASSIGNMENT_CHK dependencies on PER_ALL_ASSIGNMENTS_F

Line 19: from per_all_assignments_f asg,

15: procedure chk_Identifier(p_identifier in Varchar2)
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

Line 49: from per_all_assignments_f assign

45: l_fut_start_date date;
46:
47: Cursor csr_future_eff is
48: select effective_start_date
49: from per_all_assignments_f assign
50: where effective_start_date > p_effective_date
51: and person_id = p_person_id
52: And assign.primary_flag = 'N';
53:

Line 88: From per_all_assignments_f assign,

84: l_asg_percent_affected number;
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'

Line 98: From per_all_assignments_f assign,

94: And assign.assignment_status_type_id = 1;
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'

Line 237: from per_all_assignments_f asg, hr_soft_coding_keyflex scl

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

Line 248: from per_all_assignments_f asg, hr_soft_coding_keyflex scl

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;