APPS.PAY_IPD_BUS dependencies on PER_TIME_PERIODS

Line 379: FROM per_time_periods ptp, pay_all_payrolls_f pap

375: orig_hire_date_rec csr_orig_hire_date%ROWTYPE;
376: --
377: CURSOR csr_period_num(l_date IN DATE, l_payroll_id IN NUMBER) IS
378: SELECT ptp.period_num , ptp.start_date
379: FROM per_time_periods ptp, pay_all_payrolls_f pap
380: WHERE ptp.payroll_id = l_payroll_id
381: AND l_date BETWEEN ptp.start_date AND ptp.end_Date
382: AND ptp.period_type = pap.period_type
383: AND pap.payroll_id = l_payroll_id