APPS.HR_PAYROLLS dependencies on PER_TIME_PERIOD_TYPES

Line 34: no_periods per_time_period_types.number_per_fiscal_year%type;

30: p_multiple out nocopy number) is
31: --
32: proc_name CONSTANT varchar2(50) := 'hr_payrolls.get_period_details';
33: --
34: no_periods per_time_period_types.number_per_fiscal_year%type;
35: --
36: begin
37: hr_utility.set_location(proc_name, 1);
38: select tp.number_per_fiscal_year

Line 40: from per_time_period_types tp

36: begin
37: hr_utility.set_location(proc_name, 1);
38: select tp.number_per_fiscal_year
39: into no_periods
40: from per_time_period_types tp
41: where tp.period_type = p_proc_period_type;
42: --
43: -- Use the number of periods in a fiscal year to deduce the base
44: -- period and multiple.

Line 497: ,p_no_of_periods in per_time_period_types.number_per_fiscal_year%type

493: end derive_payroll_dates;
494: --
495: PROCEDURE chk_reset ( p_payroll_details in payroll_rec_type
496: ,p_period_number in per_time_periods.period_num%type
497: ,p_no_of_periods in per_time_period_types.number_per_fiscal_year%type
498: ,p_period_start_date in per_time_periods.start_date%type
499: ,p_next_leg_start_date in date
500: ,p_period_end_date in out nocopy per_time_periods.end_date%type
501: ,p_no_of_weeks_reset in out nocopy number ) IS

Line 694: l_display_period_type per_time_period_types.display_period_type%type ;

690: period_end_date date;
691: current_regular_pay_date date;
692: l_period_number number;
693: l_period_name per_time_periods.period_name%type ;
694: l_display_period_type per_time_period_types.display_period_type%type ;
695: l_first_period_end_date date;
696: l_period_generate_count number := 1;
697: l_tax_year number(4);
698: --

Line 699: l_no_of_periods per_time_period_types.number_per_fiscal_year%type;

695: l_first_period_end_date date;
696: l_period_generate_count number := 1;
697: l_tax_year number(4);
698: --
699: l_no_of_periods per_time_period_types.number_per_fiscal_year%type;
700: l_no_of_weeks_reset number := 0;
701: l_period_end_date date;
702: l_leap_year_offset number;
703: --

Line 706: from per_time_period_types tp

702: l_leap_year_offset number;
703: --
704: CURSOR c_get_no_of_periods IS
705: select tp.number_per_fiscal_year
706: from per_time_period_types tp
707: where tp.period_type = p_pay_det.period_type;
708: --
709: begin
710: --

Line 968: from per_time_period_types_vl tpt

964: -- Period Type.
965: --
966: select NVL(tpt.display_period_type, p_pay_det.period_type)
967: into l_display_period_type
968: from per_time_period_types_vl tpt
969: where tpt.period_type = p_pay_det.period_type;
970: --
971: -- For GB legislation we store the period number as the multiple of
972: -- constituent base period types.