APPS.HR_EMPLOYEE_APPLICANT_API dependencies on PER_CAGR_GRADES_DEF

Line 1703: from per_cagr_grades_def

1699: l_primary_scl_rec hr_soft_coding_keyflex%rowtype :=NULL;
1700: --
1701: cursor get_cag(p_cagr_grade_def_id number) is
1702: select *
1703: from per_cagr_grades_def
1704: where cagr_grade_def_id=p_cagr_grade_def_id;
1705: --
1706: l_cag_rec per_cagr_grades_def%rowtype :=NULL;
1707: l_primary_cag_rec per_cagr_grades_def%rowtype;

Line 1706: l_cag_rec per_cagr_grades_def%rowtype :=NULL;

1702: select *
1703: from per_cagr_grades_def
1704: where cagr_grade_def_id=p_cagr_grade_def_id;
1705: --
1706: l_cag_rec per_cagr_grades_def%rowtype :=NULL;
1707: l_primary_cag_rec per_cagr_grades_def%rowtype;
1708: --
1709: cursor csr_vacs(p_vacancy_id number) is
1710: select 1

Line 1707: l_primary_cag_rec per_cagr_grades_def%rowtype;

1703: from per_cagr_grades_def
1704: where cagr_grade_def_id=p_cagr_grade_def_id;
1705: --
1706: l_cag_rec per_cagr_grades_def%rowtype :=NULL;
1707: l_primary_cag_rec per_cagr_grades_def%rowtype;
1708: --
1709: cursor csr_vacs(p_vacancy_id number) is
1710: select 1
1711: from per_all_vacancies vac