DBA Data[Home] [Help]

APPS.IGS_EN_NSC_PKG dependencies on IGS_PE_EIT

Line 379: FROM igs_pe_eit perv

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