APPS.HR_CAGR_GRADES_API dependencies on PER_CAGR_GRADE_STRUCTURES

Line 138: l_id_flex_num per_cagr_grade_structures.id_flex_num%TYPE;

134: l_cagr_grade_id per_cagr_grades.cagr_grade_id%TYPE;
135: l_temp_grade_def_id per_cagr_grades.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
136: l_proc varchar2(72) := g_package||'create_cagr_grades';
137: l_object_version_number per_cagr_grades.object_version_number%TYPE;
138: l_id_flex_num per_cagr_grade_structures.id_flex_num%TYPE;
139: l_cagr_grade_def_id per_cagr_grades.cagr_grade_def_id%TYPE
140: := p_cagr_grade_def_id;
141: l_name varchar2(240) := p_concat_segments;
142: --

Line 171: from per_cagr_grade_structures pcg

167: l_null_ind number(1) := 0;
168: --
169: cursor csr_id_flex_num is
170: select pcg.id_flex_num
171: from per_cagr_grade_structures pcg
172: where pcg.cagr_grade_structure_id = p_cagr_grade_structure_id;
173: --
174: -- bug 2284889 get per_competence_definition segment values where
175: -- competence_definition_id is known

Line 512: l_id_flex_num per_cagr_grade_structures.id_flex_num%TYPE;

508: l_proc varchar2(72) := g_package||'update_cagr_grades';
509: l_segments_changed BOOLEAN;
510: l_object_version_number per_cagr_grades.object_version_number%TYPE;
511: l_ovn per_cagr_grades.object_version_number%TYPE := p_object_version_number;
512: l_id_flex_num per_cagr_grade_structures.id_flex_num%TYPE;
513: l_name varchar2(240);
514: l_cagr_grade_def_id
515: per_cagr_grades.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
516: l_temp_grade_def_id per_cagr_grades.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;

Line 545: from per_cagr_grade_structures pcs

541: l_null_ind number(1) := 0;
542: --
543: cursor csr_id_flex_num is
544: select pcs.id_flex_num
545: from per_cagr_grade_structures pcs
546: where pcs.cagr_grade_structure_id in
547: (select pcg.cagr_grade_structure_id
548: from per_cagr_grades pcg
549: where pcg.cagr_grade_id = p_cagr_grade_id);