APPS.HR_PERSON_API dependencies on PAY_PEOPLE_GROUPS

Line 2314: FROM pay_people_groups

2310: ,p_application_id in number default null)
2311: IS
2312: CURSOR get_pgp(p_people_group_id NUMBER) IS
2313: SELECT *
2314: FROM pay_people_groups
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 *

Line 2316: l_pgp_rec pay_people_groups%ROWTYPE := NULL;

2312: CURSOR get_pgp(p_people_group_id NUMBER) IS
2313: SELECT *
2314: FROM pay_people_groups
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;

Line 2723: FROM pay_people_groups

2719:
2720:
2721: CURSOR get_pgp(c_people_group_id NUMBER) IS
2722: SELECT *
2723: FROM pay_people_groups
2724: WHERE people_group_id = c_people_group_id;
2725:
2726: CURSOR get_scl(c_soft_coding_keyflex_id NUMBER) IS
2727: SELECT *

Line 2745: l_pgp_rec pay_people_groups%ROWTYPE := NULL;

2741: l_apl_ass_start_date DATE;
2742: l_party_id NUMBER;
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;

Line 2746: l_primary_pgp_rec pay_people_groups%ROWTYPE;

2742: l_party_id NUMBER;
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;