eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_NZ_HOLIDAYS dependencies on PER_ALL_ASSIGNMENTS_F

Line 140: (effective_start_date per_all_assignments_f.effective_start_date%type

136: -- Used by accrual_period_basis and ann_leave_accrual_daily_basis
137: -- functions.
138:
139: type t_asg_work_day_info_rec is record
140: (effective_start_date per_all_assignments_f.effective_start_date%type
141: ,effective_end_date per_all_assignments_f.effective_end_date%type
142: ,normal_hours per_all_assignments_f.normal_hours%type
143: ,frequency per_all_assignments_f.frequency%type) ;
144:

Line 141: ,effective_end_date per_all_assignments_f.effective_end_date%type

137: -- functions.
138:
139: type t_asg_work_day_info_rec is record
140: (effective_start_date per_all_assignments_f.effective_start_date%type
141: ,effective_end_date per_all_assignments_f.effective_end_date%type
142: ,normal_hours per_all_assignments_f.normal_hours%type
143: ,frequency per_all_assignments_f.frequency%type) ;
144:
145: type t_asg_work_day_info_tab

Line 142: ,normal_hours per_all_assignments_f.normal_hours%type

138:
139: type t_asg_work_day_info_rec is record
140: (effective_start_date per_all_assignments_f.effective_start_date%type
141: ,effective_end_date per_all_assignments_f.effective_end_date%type
142: ,normal_hours per_all_assignments_f.normal_hours%type
143: ,frequency per_all_assignments_f.frequency%type) ;
144:
145: type t_asg_work_day_info_tab
146: is table of t_asg_work_day_info_rec

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

139: type t_asg_work_day_info_rec is record
140: (effective_start_date per_all_assignments_f.effective_start_date%type
141: ,effective_end_date per_all_assignments_f.effective_end_date%type
142: ,normal_hours per_all_assignments_f.normal_hours%type
143: ,frequency per_all_assignments_f.frequency%type) ;
144:
145: type t_asg_work_day_info_tab
146: is table of t_asg_work_day_info_rec
147: index by binary_integer ;

Line 1110: per_all_assignments_f asg,

1106: FROM pay_element_entries_f pee,
1107: pay_element_entry_values_f pev,
1108: pay_input_values_f piv,
1109: pay_accrual_plans pap,
1110: per_all_assignments_f asg,
1111: per_periods_of_service pps
1112: WHERE pev.element_entry_id = pee.element_entry_id
1113: AND pap.accrual_plan_element_type_id = piv.element_type_id
1114: AND piv.input_value_id = pev.input_value_id

Line 1275: per_all_assignments_f paa

1271: CURSOR csr_get_payroll_end_date(c_assignment_id NUMBER
1272: ,c_calculation_date DATE) IS
1273: SELECT ptp.end_date
1274: FROM per_time_periods ptp,
1275: per_all_assignments_f paa
1276: WHERE ptp.payroll_id = paa.payroll_id
1277: AND paa.assignment_id = c_assignment_id
1278: AND c_calculation_date BETWEEN ptp.start_date AND ptp.end_date;
1279:

Line 2671: l_asg_working_hours per_all_assignments_f.normal_hours%type ;

2667: l_days_in_part_period integer ;
2668: l_start_date date ;
2669: l_end_date date ;
2670: l_period_accrual number ;
2671: l_asg_working_hours per_all_assignments_f.normal_hours%type ;
2672: l_pay_periods_per_year per_time_period_types.number_per_fiscal_year%type ;
2673:
2674: e_accrual_function_failure exception ;
2675:

Line 2781: l_asg_working_hours per_all_assignments_f.normal_hours%type ;

2777: function asg_working_hours(p_effective_date date
2778: ,p_frequency varchar2) return number is
2779:
2780: l_procedure_name varchar2(61) := 'asg_working_hours' ;
2781: l_asg_working_hours per_all_assignments_f.normal_hours%type ;
2782: l_counter integer := 1 ;
2783: l_hours_notfound_flag boolean := true ;
2784:
2785: begin

Line 2980: l_asg_working_hours per_all_assignments_f.normal_hours%type ;

2976: l_next_anniversary_date date ;
2977: l_start_date date ;
2978: l_end_date date ;
2979: l_period_accrual number ;
2980: l_asg_working_hours per_all_assignments_f.normal_hours%type ;
2981: l_pay_periods_per_year per_time_period_types.number_per_fiscal_year%type ;
2982: l_calc_service_date date;
2983: l_annual_accrual_1 number;
2984: l_annual_accrual_2 number;

Line 2985: l_asg_working_hours_1 per_all_assignments_f.normal_hours%type;

2981: l_pay_periods_per_year per_time_period_types.number_per_fiscal_year%type ;
2982: l_calc_service_date date;
2983: l_annual_accrual_1 number;
2984: l_annual_accrual_2 number;
2985: l_asg_working_hours_1 per_all_assignments_f.normal_hours%type;
2986: l_asg_working_hours_2 per_all_assignments_f.normal_hours%type;
2987: l_days_in_part_period_1 integer;
2988: l_days_in_part_period_2 integer;
2989: l_counter_1 integer;

Line 2986: l_asg_working_hours_2 per_all_assignments_f.normal_hours%type;

2982: l_calc_service_date date;
2983: l_annual_accrual_1 number;
2984: l_annual_accrual_2 number;
2985: l_asg_working_hours_1 per_all_assignments_f.normal_hours%type;
2986: l_asg_working_hours_2 per_all_assignments_f.normal_hours%type;
2987: l_days_in_part_period_1 integer;
2988: l_days_in_part_period_2 integer;
2989: l_counter_1 integer;
2990: l_counter_2 integer;

Line 3104: l_asg_working_hours per_all_assignments_f.normal_hours%type ;

3100: function asg_working_hours(p_effective_date date
3101: ,p_frequency varchar2) return number is
3102:
3103: l_procedure_name varchar2(61) := 'asg_working_hours' ;
3104: l_asg_working_hours per_all_assignments_f.normal_hours%type ;
3105: l_counter integer := 1 ;
3106: l_hours_notfound_flag boolean := true ;
3107:
3108: begin

Line 3429: p_assignment_id IN per_all_assignments_f.assignment_id%type

3425: -- function to calculate average acrual rate (Bug 1422001)
3426: ---------------------------------------------------------------
3427:
3428: function average_accrual_rate(
3429: p_assignment_id IN per_all_assignments_f.assignment_id%type
3430: ,p_calculation_date IN date
3431: ,p_anniversary_date IN date
3432: ,p_asg_hours IN number ) return number is
3433:

Line 3682: (p_assignment_id in per_all_assignments_f.assignment_id%type

3678: /* Bug 2264070 This function returns the gross earnings for the calculation
3679: of Average rate */
3680:
3681: FUNCTION gross_earnings_ytd_for_retro
3682: (p_assignment_id in per_all_assignments_f.assignment_id%type
3683: ,p_effective_date in date) RETURN number IS
3684:
3685: l_balance_type_id NUMBER;
3686: l_gross_earnings NUMBER;