APPS.GHR_MLC_PKG dependencies on GHR_MASS_SALARY_CRITERIA

Line 1221: -- from ghr_mass_salary_criteria

1217:
1218: --
1219: -- Cursor to select from GHR_MASS_SALARIES - Where criteria is stored
1220: -- Before executing this package
1221: -- from ghr_mass_salary_criteria
1222:
1223: cursor ghr_msl (p_msl_id number) is
1224: select name, effective_date, mass_salary_id, user_table_id, submit_flag,
1225: executive_order_number, executive_order_date, ROWID, PA_REQUEST_ID,

Line 1443: CURSOR cur_pp_prd_per_gr(p_msl_id ghr_mass_salary_criteria.mass_salary_id%type)

1439:
1440: --
1441: -- Bug 3315432 Madhuri
1442: --
1443: CURSOR cur_pp_prd_per_gr(p_msl_id ghr_mass_salary_criteria.mass_salary_id%type)
1444: IS
1445: SELECT criteria.pay_plan pay_plan,
1446: criteria.pay_rate_determinant prd,
1447: ext.grade grade

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 1454: pay_plan ghr_mass_salary_criteria.pay_plan%type,

1450: AND criteria.mass_salary_criteria_id=ext.mass_salary_criteria_id(+);
1451:
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:

Line 1455: prd ghr_mass_salary_criteria.pay_rate_determinant%type,

1451:
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;

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;