APPS.IGS_AD_GEN_004 dependencies on IGS_GE_REF_CD_TYPE

Line 438: IGS_GE_REF_CD_TYPE rct

434: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
435: cp_crv_version_number IGS_AD_PS_APPL_INST.crv_version_number%TYPE) IS
436: SELECT crc.reference_cd
437: FROM IGS_PS_REF_CD crc,
438: IGS_GE_REF_CD_TYPE rct
439: WHERE rct.s_reference_cd_type = 'OTHER' AND
440: crc.reference_cd_type = rct.reference_cd_type AND
441: crc.course_cd = cp_course_cd AND
442: crc.version_number = cp_crv_version_number;