APPS.IGS_AD_SS_GEN_001 dependencies on IGS_PE_PERSON_ID_TYP

Line 5610: FROM IGS_PE_PERSON_ID_TYP pit

5606: sslkps.closed_flag <> 'Y');
5607:
5608: CURSOR c_person_id_type IS
5609: SELECT pit.description lookup_desc
5610: FROM IGS_PE_PERSON_ID_TYP pit
5611: WHERE pit.closed_ind <> 'Y'
5612: AND EXISTS (SELECT 1 FROM IGS_AD_SS_LOOKUPS sslkps
5613: WHERE sslkps.SS_LOOKUP_TYPE = 'PERSON_ID_TYPE' AND
5614: sslkps.admission_application_type = p_application_type AND