DBA Data[Home] [Help]

APPS.PY_ROLLBACK_PKG dependencies on PAY_PAYROLLS_F

Line 1695: cursor get_time_period_id (p_payroll_id in pay_payrolls_f.payroll_id%TYPE, p_effective_date in date) is

1691: from per_all_assignments_f paaf
1692: where paaf.assignment_id = p_assignment_id
1693: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
1694: --
1695: cursor get_time_period_id (p_payroll_id in pay_payrolls_f.payroll_id%TYPE, p_effective_date in date) is
1696: select time_period_id
1697: from per_time_periods ptp
1698: where ptp.payroll_id = p_payroll_id
1699: and p_effective_date between ptp.start_date and ptp.end_date;