APPS.GHR_CPDF_CHECK6 dependencies on GHR_POIS

Line 505: select '1' from ghr_pois

501: ,p_effective_date in date --Bug 5487271
502: ) is
503: l_dummy varchar2(1);
504: cursor c_found_poi is
505: select '1' from ghr_pois
506: where personnel_office_id =
507: substr(p_employee_National_ID,2,2)||substr(p_employee_National_ID,5,2);
508: begin
509: