APPS.IGS_AD_GEN_004 dependencies on IGS_PS_REF_CD

Line 424: v_reference_cd IGS_PS_REF_CD.reference_cd%TYPE;

420: BEGIN
421: DECLARE
422: v_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE;
423: v_crv_version_number IGS_AD_PS_APPL_INST.crv_version_number%TYPE;
424: v_reference_cd IGS_PS_REF_CD.reference_cd%TYPE;
425: CURSOR c_acai IS
426: SELECT acai.course_cd,
427: acai.crv_version_number
428: FROM IGS_AD_PS_APPL_INST acai

Line 437: FROM IGS_PS_REF_CD crc,

433: CURSOR c_crc_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