APPS.HR_AU_HOLIDAYS dependencies on PAY_ACCRUAL_BANDS

Line 53: (lower_limit pay_accrual_bands.lower_limit%type

49: -- Used by accrual_period_basis and ann_leave_accrual_daily_basis
50: -- functions.
51:
52: type t_accrual_band_rec is record
53: (lower_limit pay_accrual_bands.lower_limit%type
54: ,upper_limit pay_accrual_bands.upper_limit%type
55: ,annual_rate pay_accrual_bands.annual_rate%type) ;
56:
57: type t_accrual_band_tab

Line 54: ,upper_limit pay_accrual_bands.upper_limit%type

50: -- functions.
51:
52: type t_accrual_band_rec is record
53: (lower_limit pay_accrual_bands.lower_limit%type
54: ,upper_limit pay_accrual_bands.upper_limit%type
55: ,annual_rate pay_accrual_bands.annual_rate%type) ;
56:
57: type t_accrual_band_tab
58: is table of t_accrual_band_rec

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

51:
52: type t_accrual_band_rec is record
53: (lower_limit pay_accrual_bands.lower_limit%type
54: ,upper_limit pay_accrual_bands.upper_limit%type
55: ,annual_rate pay_accrual_bands.annual_rate%type) ;
56:
57: type t_accrual_band_tab
58: is table of t_accrual_band_rec
59: index by binary_integer ;

Line 719: from pay_accrual_bands ab

715: cursor c_accrual_bands (p_accrual_plan_id number) is
716: select ab.lower_limit
717: , ab.upper_limit
718: , ab.annual_rate
719: from pay_accrual_bands ab
720: where ab.accrual_plan_id = p_accrual_plan_id
721: order by
722: ab.lower_limit ;
723:

Line 747: l_annual_accrual pay_accrual_bands.annual_rate%type ;

743:
744: function accrual_annual_rate(p_years_service number) return number is
745:
746: l_procedure_name varchar2(61) := ' accrual_annual_rate' ;
747: l_annual_accrual pay_accrual_bands.annual_rate%type ;
748: l_counter integer := 1 ;
749: l_band_notfound_flag boolean := true ;
750:
751: begin

Line 1331: from pay_accrual_bands ab

1327:
1328: -- find lsl entitlement periods
1329: cursor c_accrual_bands (v_accrual_plan_id number) is
1330: select (ab.upper_limit - ab.lower_limit)
1331: from pay_accrual_bands ab
1332: where ab.accrual_plan_id = v_accrual_plan_id
1333: order by
1334: ab.lower_limit ;
1335: