APPS.HR_AU_HOLIDAYS dependencies on PER_ALL_ASSIGNMENTS_F

Line 86: (effective_start_date per_all_assignments_f.effective_start_date%type

82: -- Used by accrual_period_basis and ann_leave_accrual_daily_basis
83: -- functions.
84:
85: type t_asg_work_day_info_rec is record
86: (effective_start_date per_all_assignments_f.effective_start_date%type
87: ,effective_end_date per_all_assignments_f.effective_end_date%type
88: ,normal_hours per_all_assignments_f.normal_hours%type
89: ,frequency per_all_assignments_f.frequency%type) ;
90:

Line 87: ,effective_end_date per_all_assignments_f.effective_end_date%type

83: -- functions.
84:
85: type t_asg_work_day_info_rec is record
86: (effective_start_date per_all_assignments_f.effective_start_date%type
87: ,effective_end_date per_all_assignments_f.effective_end_date%type
88: ,normal_hours per_all_assignments_f.normal_hours%type
89: ,frequency per_all_assignments_f.frequency%type) ;
90:
91: type t_asg_work_day_info_tab

Line 88: ,normal_hours per_all_assignments_f.normal_hours%type

84:
85: type t_asg_work_day_info_rec is record
86: (effective_start_date per_all_assignments_f.effective_start_date%type
87: ,effective_end_date per_all_assignments_f.effective_end_date%type
88: ,normal_hours per_all_assignments_f.normal_hours%type
89: ,frequency per_all_assignments_f.frequency%type) ;
90:
91: type t_asg_work_day_info_tab
92: is table of t_asg_work_day_info_rec

Line 89: ,frequency per_all_assignments_f.frequency%type) ;

85: type t_asg_work_day_info_rec is record
86: (effective_start_date per_all_assignments_f.effective_start_date%type
87: ,effective_end_date per_all_assignments_f.effective_end_date%type
88: ,normal_hours per_all_assignments_f.normal_hours%type
89: ,frequency per_all_assignments_f.frequency%type) ;
90:
91: type t_asg_work_day_info_tab
92: is table of t_asg_work_day_info_rec
93: index by binary_integer ;

Line 1903: l_asg_working_hours per_all_assignments_f.normal_hours%type ;

1899: l_mm_dd varchar2(10);
1900: l_start_date date ;
1901: l_end_date date ;
1902: l_period_accrual number ;
1903: l_asg_working_hours per_all_assignments_f.normal_hours%type ;
1904: l_pay_periods_per_year per_time_period_types.number_per_fiscal_year%type ;
1905: e_accrual_function_failure exception ;
1906:
1907: -- cursor to get number of periods per year

Line 2015: l_asg_working_hours per_all_assignments_f.normal_hours%type ;

2011: function asg_working_hours(p_effective_date date
2012: ,p_frequency varchar2) return number is
2013:
2014: l_procedure_name varchar2(61) := ' asg_working_hours' ;
2015: l_asg_working_hours per_all_assignments_f.normal_hours%type ;
2016: l_counter integer := 1 ;
2017: l_hours_notfound_flag boolean := true ;
2018:
2019: begin