DBA Data[Home] [Help]

APPS.PSP_ROLLBACK_DIST_LINES dependencies on PAY_PAYROLLS_F

Line 71: FROM per_time_periods ptp, pay_payrolls_f ppf

67: BEGIN
68:
69: -- Fix for bug 8922889
70: SELECT ptp.period_name, ppf.payroll_name into l_period_name, l_payroll_name
71: FROM per_time_periods ptp, pay_payrolls_f ppf
72: WHERE ptp.time_period_id = payroll_control_rec.time_period_id
73: and ptp.payroll_id = ppf.payroll_id
74: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date;
75: