APPS.HR_PAYROLLS dependencies on PAY_ALL_PAYROLLS_F

Line 25: payroll_id pay_all_payrolls_f.payroll_id%type,

21: -- periods currently exist).
22: --
23: type payroll_rec_type is record
24: (
25: payroll_id pay_all_payrolls_f.payroll_id%type,
26: legislation_code fnd_territories_vl.territory_code%type,
27: no_years pay_all_payrolls_f.number_of_years%type,
28: period_type pay_all_payrolls_f.period_type%type,
29: pay_date_offset pay_all_payrolls_f.pay_date_offset%type,

Line 27: no_years pay_all_payrolls_f.number_of_years%type,

23: type payroll_rec_type is record
24: (
25: payroll_id pay_all_payrolls_f.payroll_id%type,
26: legislation_code fnd_territories_vl.territory_code%type,
27: no_years pay_all_payrolls_f.number_of_years%type,
28: period_type pay_all_payrolls_f.period_type%type,
29: pay_date_offset pay_all_payrolls_f.pay_date_offset%type,
30: cut_off_date_offset pay_all_payrolls_f.cut_off_date_offset%type,
31: pay_advice_date_offset pay_all_payrolls_f.pay_advice_date_offset%type,

Line 28: period_type pay_all_payrolls_f.period_type%type,

24: (
25: payroll_id pay_all_payrolls_f.payroll_id%type,
26: legislation_code fnd_territories_vl.territory_code%type,
27: no_years pay_all_payrolls_f.number_of_years%type,
28: period_type pay_all_payrolls_f.period_type%type,
29: pay_date_offset pay_all_payrolls_f.pay_date_offset%type,
30: cut_off_date_offset pay_all_payrolls_f.cut_off_date_offset%type,
31: pay_advice_date_offset pay_all_payrolls_f.pay_advice_date_offset%type,
32: direct_deposit_date_offset pay_all_payrolls_f.direct_deposit_date_offset%type,

Line 29: pay_date_offset pay_all_payrolls_f.pay_date_offset%type,

25: payroll_id pay_all_payrolls_f.payroll_id%type,
26: legislation_code fnd_territories_vl.territory_code%type,
27: no_years pay_all_payrolls_f.number_of_years%type,
28: period_type pay_all_payrolls_f.period_type%type,
29: pay_date_offset pay_all_payrolls_f.pay_date_offset%type,
30: cut_off_date_offset pay_all_payrolls_f.cut_off_date_offset%type,
31: pay_advice_date_offset pay_all_payrolls_f.pay_advice_date_offset%type,
32: direct_deposit_date_offset pay_all_payrolls_f.direct_deposit_date_offset%type,
33: base_period_type varchar2(1),

Line 30: cut_off_date_offset pay_all_payrolls_f.cut_off_date_offset%type,

26: legislation_code fnd_territories_vl.territory_code%type,
27: no_years pay_all_payrolls_f.number_of_years%type,
28: period_type pay_all_payrolls_f.period_type%type,
29: pay_date_offset pay_all_payrolls_f.pay_date_offset%type,
30: cut_off_date_offset pay_all_payrolls_f.cut_off_date_offset%type,
31: pay_advice_date_offset pay_all_payrolls_f.pay_advice_date_offset%type,
32: direct_deposit_date_offset pay_all_payrolls_f.direct_deposit_date_offset%type,
33: base_period_type varchar2(1),
34: multiple number,

Line 31: pay_advice_date_offset pay_all_payrolls_f.pay_advice_date_offset%type,

27: no_years pay_all_payrolls_f.number_of_years%type,
28: period_type pay_all_payrolls_f.period_type%type,
29: pay_date_offset pay_all_payrolls_f.pay_date_offset%type,
30: cut_off_date_offset pay_all_payrolls_f.cut_off_date_offset%type,
31: pay_advice_date_offset pay_all_payrolls_f.pay_advice_date_offset%type,
32: direct_deposit_date_offset pay_all_payrolls_f.direct_deposit_date_offset%type,
33: base_period_type varchar2(1),
34: multiple number,
35: first_start_date date,

Line 32: direct_deposit_date_offset pay_all_payrolls_f.direct_deposit_date_offset%type,

28: period_type pay_all_payrolls_f.period_type%type,
29: pay_date_offset pay_all_payrolls_f.pay_date_offset%type,
30: cut_off_date_offset pay_all_payrolls_f.cut_off_date_offset%type,
31: pay_advice_date_offset pay_all_payrolls_f.pay_advice_date_offset%type,
32: direct_deposit_date_offset pay_all_payrolls_f.direct_deposit_date_offset%type,
33: base_period_type varchar2(1),
34: multiple number,
35: first_start_date date,
36: first_end_date date,

Line 39: period_reset_years pay_all_payrolls_f.period_reset_years%type,

35: first_start_date date,
36: first_end_date date,
37: first_gen_start_date date,
38: first_gen_end_date date,
39: period_reset_years pay_all_payrolls_f.period_reset_years%type,
40: payslip_view_date_offset pay_all_payrolls_f.payslip_view_date_offset%type
41: );
42: --
43: -- The entry point to the package, both for initial creation of

Line 40: payslip_view_date_offset pay_all_payrolls_f.payslip_view_date_offset%type

36: first_end_date date,
37: first_gen_start_date date,
38: first_gen_end_date date,
39: period_reset_years pay_all_payrolls_f.period_reset_years%type,
40: payslip_view_date_offset pay_all_payrolls_f.payslip_view_date_offset%type
41: );
42: --
43: -- The entry point to the package, both for initial creation of
44: -- periods and creaion of further periods.

Line 54: --additional parameter p_effective_date and using PAY_ALL_PAYROLLS_F

50: p_created_by in number,
51: p_creation_date in date);
52: --
53: --This is a overloaded version of create_payroll_proc_periods with
54: --additional parameter p_effective_date and using PAY_ALL_PAYROLLS_F
55: --table instead of PAY_ALL_PAYROLLS view.
56: --
57: procedure create_payroll_proc_periods (p_payroll_id in number,
58: p_last_update_date in date,