APPS.GHR_CPDF_CHECK6 dependencies on GHR_POIS

Line 450: select '1' from ghr_pois

446: ,p_effective_date in date --Bug 5487271
447: ) is
448: l_dummy varchar2(1);
449: cursor c_found_poi is
450: select '1' from ghr_pois
451: where personnel_office_id =
452: substr(p_employee_National_ID,2,2)||substr(p_employee_National_ID,5,2);
453: begin
454: