APPS.PER_IN_PERQUISITE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 880: per_all_assignments_f paa

876: ,p_assignment_id NUMBER)
877: IS
878: SELECT sum(nvl(ppm.pem_information8,0))
879: FROM per_previous_employers ppm,
880: per_all_assignments_f paa
881: WHERE paa.assignment_id = p_assignment_id
882: AND p_effective_start_date BETWEEN paa.effective_start_date AND paa.effective_end_date
883: AND paa.person_id =ppm.person_id
884: AND ppm.end_date BETWEEN p_start_date and p_end_date;