375:
376: --Checks the res_status and SSN of the person
377: CURSOR c_validate_person_id (cp_person_id igs_pe_person.person_id%type) IS
378: SELECT cst_valid 379: FROM igs_pe_eit perv 380: WHERE perv.person_id=cp_person_id
381: AND information_type = 'PE_STAT_RES_STATUS'
382: AND perv.pei_information1 NOT IN
383: (SELECT opt_val