DBA Data[Home] [Help]

APPS.PAY_SID_BUS dependencies on PER_TIME_PERIODS

Line 625: FROM per_time_periods ptp, pay_all_payrolls_f pap, per_all_assignments_f paa

621: ) RETURN NUMBER IS
622: --
623: CURSOR get_period_info IS
624: SELECT ptp.time_period_id, ptp.start_Date, ptp.end_date
625: FROM per_time_periods ptp, pay_all_payrolls_f pap, per_all_assignments_f paa
626: WHERE ptp.payroll_id = pap.payroll_id
627: AND p_effective_date BETWEEN ptp.start_date AND ptp.end_date
628: AND pap.payroll_id = paa.payroll_id
629: AND p_effective_date BETWEEN pap.effective_start_date AND pap.effective_end_date