APPS.HR_PERSON_API dependencies on HR_SOFT_CODING_KEYFLEX

Line 2319: FROM hr_soft_coding_keyflex

2315: WHERE people_group_id = p_people_group_id;
2316: l_pgp_rec pay_people_groups%ROWTYPE := NULL;
2317: CURSOR get_scl(p_soft_coding_keyflex_id NUMBER) IS
2318: SELECT *
2319: FROM hr_soft_coding_keyflex
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 *

Line 2321: l_scl_rec hr_soft_coding_keyflex%ROWTYPE := NULL;

2317: CURSOR get_scl(p_soft_coding_keyflex_id NUMBER) IS
2318: SELECT *
2319: FROM hr_soft_coding_keyflex
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;

Line 2728: FROM hr_soft_coding_keyflex

2724: WHERE people_group_id = c_people_group_id;
2725:
2726: CURSOR get_scl(c_soft_coding_keyflex_id NUMBER) IS
2727: SELECT *
2728: FROM hr_soft_coding_keyflex
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 *

Line 2747: l_scl_rec hr_soft_coding_keyflex%ROWTYPE := NULL;

2743: l_person_org_manager_warning VARCHAR2(1000);
2744: l_per_assign_record assign_record%ROWTYPE;
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);

Line 2748: l_primary_scl_rec hr_soft_coding_keyflex%ROWTYPE := NULL;

2744: l_per_assign_record assign_record%ROWTYPE;
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;