DBA Data[Home] [Help]

APPS.HR_AU_HOLIDAYS dependencies on PER_TIME_PERIOD_TYPES

Line 682: l_pay_periods_per_year per_time_period_types.number_per_fiscal_year%type ;

678: l_start_date date ;
679: l_end_date date ;
680: l_period_accrual number ;
681: l_asg_working_hours per_all_assignments_f.normal_hours%type ;
682: l_pay_periods_per_year per_time_period_types.number_per_fiscal_year%type ;
683: e_accrual_function_failure exception ;
684:
685: -- cursor to get number of periods per year
686:

Line 691: , per_time_period_types tpt

687: cursor c_number_of_periods_per_year (p_payroll_id number
688: ,p_effective_date date) is
689: select tpt.number_per_fiscal_year
690: from pay_payrolls_f p
691: , per_time_period_types tpt
692: where p.payroll_id = p_payroll_id
693: and p_effective_date between p.effective_start_date
694: and p.effective_end_date
695: and tpt.period_type = p.period_type ;