APPS.IGS_AD_SS_GEN_001 dependencies on IGS_AD_CRED_TYPES

Line 5660: FROM IGS_AD_CRED_TYPES act

5656: sslkps.closed_flag <> 'Y');
5657:
5658: CURSOR c_credential_type IS
5659: SELECT act.description lookup_desc
5660: FROM IGS_AD_CRED_TYPES act
5661: WHERE act.closed_ind <> 'Y'
5662: AND EXISTS (SELECT 1 FROM IGS_AD_SS_LOOKUPS sslkps
5663: WHERE sslkps.ss_lookup_type = 'CREDENTIAL_TYPE' AND
5664: sslkps.admission_application_type = p_application_type AND