APPS.HR_EMPLOYEE_APPLICANT_API dependencies on PER_CAGR_GRADES_DEF

Line 1924: from per_cagr_grades_def

1920: l_primary_scl_rec hr_soft_coding_keyflex%rowtype :=NULL;
1921: --
1922: cursor get_cag(p_cagr_grade_def_id number) is
1923: select *
1924: from per_cagr_grades_def
1925: where cagr_grade_def_id=p_cagr_grade_def_id;
1926: --
1927: l_cag_rec per_cagr_grades_def%rowtype :=NULL;
1928: l_primary_cag_rec per_cagr_grades_def%rowtype;

Line 1927: l_cag_rec per_cagr_grades_def%rowtype :=NULL;

1923: select *
1924: from per_cagr_grades_def
1925: where cagr_grade_def_id=p_cagr_grade_def_id;
1926: --
1927: l_cag_rec per_cagr_grades_def%rowtype :=NULL;
1928: l_primary_cag_rec per_cagr_grades_def%rowtype;
1929: --
1930: cursor csr_vacs(p_vacancy_id number) is
1931: select 1

Line 1928: l_primary_cag_rec per_cagr_grades_def%rowtype;

1924: from per_cagr_grades_def
1925: where cagr_grade_def_id=p_cagr_grade_def_id;
1926: --
1927: l_cag_rec per_cagr_grades_def%rowtype :=NULL;
1928: l_primary_cag_rec per_cagr_grades_def%rowtype;
1929: --
1930: cursor csr_vacs(p_vacancy_id number) is
1931: select 1
1932: from per_all_vacancies vac

Line 4405: from per_cagr_grades_def

4401: l_primary_scl_rec hr_soft_coding_keyflex%rowtype :=NULL;
4402: --
4403: cursor get_cag(p_cagr_grade_def_id number) is
4404: select *
4405: from per_cagr_grades_def
4406: where cagr_grade_def_id=p_cagr_grade_def_id;
4407: --
4408: l_cag_rec per_cagr_grades_def%rowtype :=NULL;
4409: l_primary_cag_rec per_cagr_grades_def%rowtype;

Line 4408: l_cag_rec per_cagr_grades_def%rowtype :=NULL;

4404: select *
4405: from per_cagr_grades_def
4406: where cagr_grade_def_id=p_cagr_grade_def_id;
4407: --
4408: l_cag_rec per_cagr_grades_def%rowtype :=NULL;
4409: l_primary_cag_rec per_cagr_grades_def%rowtype;
4410: --
4411: cursor csr_vacs(p_vacancy_id number) is
4412: select 1

Line 4409: l_primary_cag_rec per_cagr_grades_def%rowtype;

4405: from per_cagr_grades_def
4406: where cagr_grade_def_id=p_cagr_grade_def_id;
4407: --
4408: l_cag_rec per_cagr_grades_def%rowtype :=NULL;
4409: l_primary_cag_rec per_cagr_grades_def%rowtype;
4410: --
4411: cursor csr_vacs(p_vacancy_id number) is
4412: select 1
4413: from per_all_vacancies vac