APPS.HR_NZ_HOLIDAYS dependencies on PAY_ACCRUAL_BANDS

Line 127: (lower_limit pay_accrual_bands.lower_limit%type

123: -- Used by accrual_period_basis and ann_leave_accrual_daily_basis
124: -- functions.
125:
126: type t_accrual_band_rec is record
127: (lower_limit pay_accrual_bands.lower_limit%type
128: ,upper_limit pay_accrual_bands.upper_limit%type
129: ,annual_rate pay_accrual_bands.annual_rate%type) ;
130:
131: type t_accrual_band_tab

Line 128: ,upper_limit pay_accrual_bands.upper_limit%type

124: -- functions.
125:
126: type t_accrual_band_rec is record
127: (lower_limit pay_accrual_bands.lower_limit%type
128: ,upper_limit pay_accrual_bands.upper_limit%type
129: ,annual_rate pay_accrual_bands.annual_rate%type) ;
130:
131: type t_accrual_band_tab
132: is table of t_accrual_band_rec

Line 129: ,annual_rate pay_accrual_bands.annual_rate%type) ;

125:
126: type t_accrual_band_rec is record
127: (lower_limit pay_accrual_bands.lower_limit%type
128: ,upper_limit pay_accrual_bands.upper_limit%type
129: ,annual_rate pay_accrual_bands.annual_rate%type) ;
130:
131: type t_accrual_band_tab
132: is table of t_accrual_band_rec
133: index by binary_integer ;

Line 1283: FROM pay_accrual_bands

1279:
1280: CURSOR csr_get_accrual_band (c_number_of_years NUMBER
1281: ,c_accrual_plan_id NUMBER) IS
1282: SELECT annual_rate
1283: FROM pay_accrual_bands
1284: WHERE c_number_of_years >= lower_limit
1285: AND c_number_of_years < upper_limit
1286: AND accrual_plan_id = c_accrual_plan_id;
1287:

Line 2710: from pay_accrual_bands ab

2706: cursor c_accrual_bands (p_accrual_plan_id number) is
2707: select ab.lower_limit
2708: , ab.upper_limit
2709: , ab.annual_rate
2710: from pay_accrual_bands ab
2711: where ab.accrual_plan_id = p_accrual_plan_id
2712: order by
2713: ab.lower_limit ;
2714:

Line 2734: l_annual_accrual pay_accrual_bands.annual_rate%type ;

2730:
2731: function accrual_annual_rate(p_years_service number) return number is
2732:
2733: l_procedure_name varchar2(61) := 'accrual_annual_rate' ;
2734: l_annual_accrual pay_accrual_bands.annual_rate%type ;
2735: l_counter integer := 1 ;
2736: l_band_notfound_flag boolean := true ;
2737:
2738: begin

Line 3029: from pay_accrual_bands ab

3025: cursor c_accrual_bands (p_accrual_plan_id number) is
3026: select ab.lower_limit
3027: , ab.upper_limit
3028: , ab.annual_rate
3029: from pay_accrual_bands ab
3030: where ab.accrual_plan_id = p_accrual_plan_id
3031: order by
3032: ab.lower_limit ;
3033:

Line 3053: l_annual_accrual pay_accrual_bands.annual_rate%type ;

3049:
3050: function accrual_annual_rate(p_years_service number) return number is
3051:
3052: l_procedure_name varchar2(61) := 'accrual_annual_rate' ;
3053: l_annual_accrual pay_accrual_bands.annual_rate%type ;
3054: l_counter integer := 1 ;
3055: l_band_notfound_flag boolean := true ;
3056:
3057: begin