DBA Data[Home] [Help]

APPS.GHR_MLC_PKG dependencies on GHR_MASS_SALARY_CRITERIA_EXT

Line 1422: FROM ghr_mass_salary_criteria criteria, ghr_mass_salary_criteria_ext ext

1418: IS
1419: SELECT criteria.pay_plan pay_plan,
1420: criteria.pay_rate_determinant prd,
1421: ext.grade grade
1422: FROM ghr_mass_salary_criteria criteria, ghr_mass_salary_criteria_ext ext
1423: WHERE criteria.mass_salary_id=p_msl_id
1424: AND criteria.mass_salary_criteria_id=ext.mass_salary_criteria_id(+);
1425:
1426: TYPE pay_plan_prd_per_gr IS RECORD

Line 1430: grade ghr_mass_salary_criteria_ext.grade%type

1426: TYPE pay_plan_prd_per_gr IS RECORD
1427: (
1428: pay_plan ghr_mass_salary_criteria.pay_plan%type,
1429: prd ghr_mass_salary_criteria.pay_rate_determinant%type,
1430: grade ghr_mass_salary_criteria_ext.grade%type
1431: );
1432:
1433: TYPE pp_prd_per_gr IS TABLE OF pay_plan_prd_per_gr INDEX BY BINARY_INTEGER;
1434: rec_pp_prd_per_gr pp_prd_per_gr;