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