APPS.GHR_MLC_PKG dependencies on GHR_MASS_SALARY_CRITERIA

Line 1197: -- from ghr_mass_salary_criteria

1193:
1194: --
1195: -- Cursor to select from GHR_MASS_SALARIES - Where criteria is stored
1196: -- Before executing this package
1197: -- from ghr_mass_salary_criteria
1198:
1199: cursor ghr_msl (p_msl_id number) is
1200: select name, effective_date, mass_salary_id, user_table_id, submit_flag,
1201: executive_order_number, executive_order_date, ROWID, PA_REQUEST_ID,

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

1413:
1414: --
1415: -- Bug 3315432 Madhuri
1416: --
1417: CURSOR cur_pp_prd_per_gr(p_msl_id ghr_mass_salary_criteria.mass_salary_id%type)
1418: IS
1419: SELECT criteria.pay_plan pay_plan,
1420: criteria.pay_rate_determinant prd,
1421: ext.grade grade

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

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

Line 1429: prd ghr_mass_salary_criteria.pay_rate_determinant%type,

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

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;