DBA Data[Home] [Help]

APPS.HR_PAYROLLS dependencies on PAY_ALL_PAYROLLS_F

Line 683: payroll_start_date pay_all_payrolls_f.effective_start_date%type;

679: --
680: proc_name CONSTANT varchar2(50) := 'hr_payrolls.insert_proc_periods';
681: --
682: per_num number; -- Monotonic period number, not displayed.
683: payroll_start_date pay_all_payrolls_f.effective_start_date%type;
684: payroll_end_date pay_all_payrolls_f.effective_end_date%type;
685: within_period_flag boolean := FALSE;
686: leg_start_date date;
687: end_years_marker date;

Line 684: payroll_end_date pay_all_payrolls_f.effective_end_date%type;

680: proc_name CONSTANT varchar2(50) := 'hr_payrolls.insert_proc_periods';
681: --
682: per_num number; -- Monotonic period number, not displayed.
683: payroll_start_date pay_all_payrolls_f.effective_start_date%type;
684: payroll_end_date pay_all_payrolls_f.effective_end_date%type;
685: within_period_flag boolean := FALSE;
686: leg_start_date date;
687: end_years_marker date;
688: next_leg_start_date date;

Line 717: from pay_all_payrolls_f ppy

713: select min(ppy.effective_start_date),
714: max(ppy.effective_end_date)
715: into payroll_start_date,
716: payroll_end_date
717: from pay_all_payrolls_f ppy
718: where ppy.payroll_id = p_pay_det.payroll_id;
719: --
720: --
721: -- The periods generated must exist within the lifetime of the

Line 907: update pay_all_payrolls_f

903:
904: p_pay_det.first_end_date := period_end_date;
905: p_pay_det.first_gen_end_date := period_end_date;
906:
907: update pay_all_payrolls_f
908: set first_period_end_date = period_end_date
909: where payroll_id = p_pay_det.payroll_id;
910:
911: -- Set the warning variable

Line 1311: --additional parameter p_effective_date and using PAY_ALL_PAYROLLS_F

1307: --
1308: end create_payroll_proc_periods;
1309: ------------------------------------------------------------------------------------
1310: --This is a overloaded version of create_payroll_proc_periods with
1311: --additional parameter p_effective_date and using PAY_ALL_PAYROLLS_F
1312: --table instead of PAY_ALL_PAYROLLS view.
1313: --
1314: procedure create_payroll_proc_periods (p_payroll_id in number,
1315: p_last_update_date in date,

Line 1354: from pay_all_payrolls_f ppy,

1350: payroll_details.direct_deposit_date_offset,
1351: payroll_details.first_end_date,
1352: payroll_details.legislation_code,
1353: payroll_details.payslip_view_date_offset
1354: from pay_all_payrolls_f ppy,
1355: per_business_groups pbg
1356: where ppy.payroll_id = p_payroll_id
1357: and ppy.business_group_id + 0 = pbg.business_group_id + 0
1358: and ppy.effective_start_date <= p_effective_date