APPS.PER_IN_PERQUISITE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 868: per_all_assignments_f paa

864: ,p_assignment_id NUMBER)
865: IS
866: SELECT sum(nvl(ppm.pem_information8,0))
867: FROM per_previous_employers ppm,
868: per_all_assignments_f paa
869: WHERE paa.assignment_id = p_assignment_id
870: AND p_effective_start_date BETWEEN paa.effective_start_date AND paa.effective_end_date
871: AND paa.person_id =ppm.person_id
872: AND ppm.end_date BETWEEN p_start_date and p_end_date;