DBA Data[Home] [Help]

APPS.PAY_SIMULATOR_SS_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 228: FROM pay_all_payrolls_f papf

224: CURSOR get_dates IS
225: SELECT ptp.start_date
226: , ptp.end_date
227: , ptp.regular_payment_date
228: FROM pay_all_payrolls_f papf
229: , per_time_periods ptp
230: WHERE papf.payroll_id = p_payroll_id
231: AND trunc(p_run_date)
232: BETWEEN papf.effective_start_date

Line 554: FROM pay_all_payrolls_f papf

550: CURSOR get_dates IS
551: SELECT ptp.start_date
552: , ptp.end_date
553: , ptp.regular_payment_date
554: FROM pay_all_payrolls_f papf
555: , per_time_periods ptp
556: , per_all_assignments_f paf
557: WHERE papf.payroll_id = paf.payroll_id
558: AND paf.assignment_id = p_assignment_id