APPS.PER_ASG_BUS3 dependencies on PER_CAGR_GRADE_STRUCTURES

Line 41: from per_cagr_grade_structures cgs

37: and pcg.cagr_grade_def_id = p_cagr_grade_def_id;
38: --
39: cursor csr_in_cagr_grade_structs is
40: select dynamic_insert_allowed, cagr_grade_structure_id
41: from per_cagr_grade_structures cgs
42: where cgs.id_flex_num = p_cagr_id_flex_num
43: and cgs.collective_agreement_id = p_collective_agreement_id;
44: --
45: cursor csr_in_cagr_grades is

Line 114: -- It must exist in per_cagr_grade_structures

110: hr_utility.raise_error;
111: Else
112: close csr_in_per_cagr_grades_def;
113: End If;
114: -- It must exist in per_cagr_grade_structures
115: Open csr_in_cagr_grade_structs;
116: Fetch csr_in_cagr_grade_structs Into l_dynamic_insert_allowed,
117: l_cagr_grade_structure_id;
118: If csr_in_cagr_grade_structs%notfound then

Line 172: from per_cagr_grade_structures cgs

168: where fnd.id_flex_code = 'CAGR';
169: --
170: cursor csr_in_cagr_grade_structs is
171: select null
172: from per_cagr_grade_structures cgs
173: where cgs.id_flex_num = p_cagr_id_flex_num
174: and cgs.collective_agreement_id = p_collective_agreement_id;
175: --
176: begin

Line 237: -- If there is a collective_agreement_id it must be on per_cagr_grade_structures

233: hr_multi_message.add;
234: Else
235: Close csr_in_fnd_id_flex;
236: --
237: -- If there is a collective_agreement_id it must be on per_cagr_grade_structures
238: If p_collective_agreement_id is not null THEN
239: Open csr_in_cagr_grade_structs;
240: fetch csr_in_cagr_grade_structs into l_exists;
241: If csr_in_cagr_grade_structs%notfound then