13:
14: -- Bug#5063304 Moved this type definition from execute_msl to global level.
15: TYPE pay_plan_prd IS RECORD
16: (
17: pay_plan ghr_mass_salary_criteria.pay_plan%type,
18: prd ghr_mass_salary_criteria.pay_rate_determinant%type
19: );
20:
21: TYPE pp_prd IS TABLE OF pay_plan_prd INDEX BY BINARY_INTEGER;
14: -- Bug#5063304 Moved this type definition from execute_msl to global level.
15: TYPE pay_plan_prd IS RECORD
16: (
17: pay_plan ghr_mass_salary_criteria.pay_plan%type,
18: prd ghr_mass_salary_criteria.pay_rate_determinant%type
19: );
20:
21: TYPE pp_prd IS TABLE OF pay_plan_prd INDEX BY BINARY_INTEGER;
22:
21: TYPE pp_prd IS TABLE OF pay_plan_prd INDEX BY BINARY_INTEGER;
22:
23: TYPE pay_plan_prd_per_gr IS RECORD
24: (
25: pay_plan ghr_mass_salary_criteria.pay_plan%type,
26: prd ghr_mass_salary_criteria.pay_rate_determinant%type,
27: percent ghr_mass_salary_criteria_ext.increase_percent%type,
28: grade ghr_mass_salary_criteria_ext.grade%type
29: );
22:
23: TYPE pay_plan_prd_per_gr IS RECORD
24: (
25: pay_plan ghr_mass_salary_criteria.pay_plan%type,
26: prd ghr_mass_salary_criteria.pay_rate_determinant%type,
27: percent ghr_mass_salary_criteria_ext.increase_percent%type,
28: grade ghr_mass_salary_criteria_ext.grade%type
29: );
30:
23: TYPE pay_plan_prd_per_gr IS RECORD
24: (
25: pay_plan ghr_mass_salary_criteria.pay_plan%type,
26: prd ghr_mass_salary_criteria.pay_rate_determinant%type,
27: percent ghr_mass_salary_criteria_ext.increase_percent%type,
28: grade ghr_mass_salary_criteria_ext.grade%type
29: );
30:
31: TYPE pp_prd_per_gr IS TABLE OF pay_plan_prd_per_gr INDEX BY BINARY_INTEGER;
24: (
25: pay_plan ghr_mass_salary_criteria.pay_plan%type,
26: prd ghr_mass_salary_criteria.pay_rate_determinant%type,
27: percent ghr_mass_salary_criteria_ext.increase_percent%type,
28: grade ghr_mass_salary_criteria_ext.grade%type
29: );
30:
31: TYPE pp_prd_per_gr IS TABLE OF pay_plan_prd_per_gr INDEX BY BINARY_INTEGER;
32: