DBA Data[Home] [Help]

APPS.GHR_MLC_PKG dependencies on GHR_MASS_SALARY_CRITERIA_EXT

Line 1448: FROM ghr_mass_salary_criteria criteria, ghr_mass_salary_criteria_ext ext

1444: IS
1445: SELECT criteria.pay_plan pay_plan,
1446: criteria.pay_rate_determinant prd,
1447: ext.grade grade
1448: FROM ghr_mass_salary_criteria criteria, ghr_mass_salary_criteria_ext ext
1449: WHERE criteria.mass_salary_id=p_msl_id
1450: AND criteria.mass_salary_criteria_id=ext.mass_salary_criteria_id(+);
1451:
1452: TYPE pay_plan_prd_per_gr IS RECORD

Line 1456: grade ghr_mass_salary_criteria_ext.grade%type

1452: TYPE pay_plan_prd_per_gr IS RECORD
1453: (
1454: pay_plan ghr_mass_salary_criteria.pay_plan%type,
1455: prd ghr_mass_salary_criteria.pay_rate_determinant%type,
1456: grade ghr_mass_salary_criteria_ext.grade%type
1457: );
1458:
1459: TYPE pp_prd_per_gr IS TABLE OF pay_plan_prd_per_gr INDEX BY BINARY_INTEGER;
1460: rec_pp_prd_per_gr pp_prd_per_gr;