APPS.PAY_IN_EOY_REPORTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 774: FROM per_all_assignments_f paf

770:
771: CURSOR csr_payroll_id(p_assignment_id NUMBER,p_date DATE)
772: IS
773: SELECT paf.payroll_id
774: FROM per_all_assignments_f paf
775: WHERE paf.assignment_id =p_assignment_id
776: AND p_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
777:
778: l_total_pay_period NUMBER;