APPS.HR_AU_HOLIDAYS dependencies on PAY_ACCRUAL_BANDS

Line 73: (lower_limit pay_accrual_bands.lower_limit%type

69: -- Used by accrual_period_basis and ann_leave_accrual_daily_basis
70: -- functions.
71:
72: type t_accrual_band_rec is record
73: (lower_limit pay_accrual_bands.lower_limit%type
74: ,upper_limit pay_accrual_bands.upper_limit%type
75: ,annual_rate pay_accrual_bands.annual_rate%type) ;
76:
77: type t_accrual_band_tab

Line 74: ,upper_limit pay_accrual_bands.upper_limit%type

70: -- functions.
71:
72: type t_accrual_band_rec is record
73: (lower_limit pay_accrual_bands.lower_limit%type
74: ,upper_limit pay_accrual_bands.upper_limit%type
75: ,annual_rate pay_accrual_bands.annual_rate%type) ;
76:
77: type t_accrual_band_tab
78: is table of t_accrual_band_rec

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

71:
72: type t_accrual_band_rec is record
73: (lower_limit pay_accrual_bands.lower_limit%type
74: ,upper_limit pay_accrual_bands.upper_limit%type
75: ,annual_rate pay_accrual_bands.annual_rate%type) ;
76:
77: type t_accrual_band_tab
78: is table of t_accrual_band_rec
79: index by binary_integer ;

Line 1941: from pay_accrual_bands ab

1937: cursor c_accrual_bands (p_accrual_plan_id number) is
1938: select ab.lower_limit
1939: , ab.upper_limit
1940: , ab.annual_rate
1941: from pay_accrual_bands ab
1942: where ab.accrual_plan_id = p_accrual_plan_id
1943: order by
1944: ab.lower_limit ;
1945:

Line 1969: l_annual_accrual pay_accrual_bands.annual_rate%type ;

1965:
1966: function accrual_annual_rate(p_years_service number) return number is
1967:
1968: l_procedure_name varchar2(61) := ' accrual_annual_rate' ;
1969: l_annual_accrual pay_accrual_bands.annual_rate%type ;
1970: l_counter integer := 1 ;
1971: l_band_notfound_flag boolean := true ;
1972:
1973: begin

Line 2562: from pay_accrual_bands ab

2558:
2559: -- find lsl entitlement periods
2560: cursor c_accrual_bands (v_accrual_plan_id number) is
2561: select (ab.upper_limit - ab.lower_limit)
2562: from pay_accrual_bands ab
2563: where ab.accrual_plan_id = v_accrual_plan_id
2564: order by
2565: ab.lower_limit ;
2566: