APPS.HR_PERSON_API dependencies on PER_CAGR_GRADES_DEF

Line 2324: FROM per_cagr_grades_def

2320: WHERE soft_coding_keyflex_id = p_soft_coding_keyflex_id;
2321: l_scl_rec hr_soft_coding_keyflex%ROWTYPE := NULL;
2322: CURSOR get_cag(p_cagr_grade_def_id NUMBER) IS
2323: SELECT *
2324: FROM per_cagr_grades_def
2325: WHERE cagr_grade_def_id = p_cagr_grade_def_id;
2326: l_cag_rec per_cagr_grades_def%ROWTYPE := NULL;
2327: CURSOR assignment_record_update IS
2328: SELECT *

Line 2326: l_cag_rec per_cagr_grades_def%ROWTYPE := NULL;

2322: CURSOR get_cag(p_cagr_grade_def_id NUMBER) IS
2323: SELECT *
2324: FROM per_cagr_grades_def
2325: WHERE cagr_grade_def_id = p_cagr_grade_def_id;
2326: l_cag_rec per_cagr_grades_def%ROWTYPE := NULL;
2327: CURSOR assignment_record_update IS
2328: SELECT *
2329: FROM per_all_assignments_f
2330: WHERE assignment_id = s_assignment_id

Line 2733: FROM per_cagr_grades_def

2729: WHERE soft_coding_keyflex_id = c_soft_coding_keyflex_id;
2730:
2731: CURSOR get_cag(c_cagr_grade_def_id NUMBER) IS
2732: SELECT *
2733: FROM per_cagr_grades_def
2734: WHERE cagr_grade_def_id = c_cagr_grade_def_id;
2735:
2736: l_t_person_type VARCHAR2(39);
2737: l_s_person_type VARCHAR2(39);

Line 2749: l_cag_rec per_cagr_grades_def%ROWTYPE := NULL;

2745: l_pgp_rec pay_people_groups%ROWTYPE := NULL;
2746: l_primary_pgp_rec pay_people_groups%ROWTYPE;
2747: l_scl_rec hr_soft_coding_keyflex%ROWTYPE := NULL;
2748: l_primary_scl_rec hr_soft_coding_keyflex%ROWTYPE := NULL;
2749: l_cag_rec per_cagr_grades_def%ROWTYPE := NULL;
2750: l_primary_cag_rec per_cagr_grades_def%ROWTYPE;
2751: l_concatenated_segments VARCHAR2(1000);
2752: l_cagr_grade_def_id NUMBER;
2753: l_people_group_id NUMBER;

Line 2750: l_primary_cag_rec per_cagr_grades_def%ROWTYPE;

2746: l_primary_pgp_rec pay_people_groups%ROWTYPE;
2747: l_scl_rec hr_soft_coding_keyflex%ROWTYPE := NULL;
2748: l_primary_scl_rec hr_soft_coding_keyflex%ROWTYPE := NULL;
2749: l_cag_rec per_cagr_grades_def%ROWTYPE := NULL;
2750: l_primary_cag_rec per_cagr_grades_def%ROWTYPE;
2751: l_concatenated_segments VARCHAR2(1000);
2752: l_cagr_grade_def_id NUMBER;
2753: l_people_group_id NUMBER;
2754: l_soft_coding_keyflex_id NUMBER;