APPS.IGS_AD_GEN_010 dependencies on IGS_GE_REF_CD_TYPE

Line 78: v_ref_cd_type IGS_GE_REF_CD_TYPE.reference_cd_type%TYPE;

74: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;
75: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;
76: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;
77: v_coo_id IGS_PS_ENT_PT_REF_CD.coo_id%TYPE;
78: v_ref_cd_type IGS_GE_REF_CD_TYPE.reference_cd_type%TYPE;
79: v_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE;
80: v_us_version_number IGS_EN_UNIT_SET.version_number%TYPE;
81: v_message_name varchar2(30);
82: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';

Line 95: IGS_GE_REF_CD_TYPE rct,

91: rct.s_reference_cd_type,
92: ceprc.unit_set_cd,
93: ceprc.us_version_number
94: FROM IGS_PS_ENT_PT_REF_CD ceprc,
95: IGS_GE_REF_CD_TYPE rct,
96: IGS_PS_VER crv,
97: IGS_PS_STAT cs
98: WHERE rct.s_reference_cd_type = 'OTHER' AND
99: ceprc.reference_cd_type = rct.reference_cd_type AND

Line 262: IGS_GE_REF_CD_TYPE rct,

258: ceprc.location_cd,
259: ceprc.attendance_mode,
260: ceprc.attendance_type
261: FROM IGS_PS_ENT_PT_REF_CD ceprc,
262: IGS_GE_REF_CD_TYPE rct,
263: IGS_PS_VER crv,
264: IGS_PS_STAT cs
265: WHERE rct.s_reference_cd_type = 'OTHER' AND
266: ceprc.reference_cd_type = rct.reference_cd_type AND

Line 321: IGS_GE_REF_CD_TYPE rct

317: IGS_AD_PS_APPL_INST acaiv, /* Replaced IGS_AD_PS_APPL_INST_APLINST_V with IGS_AD_PS_APPL_INST. Bug 3150054 */
318: IGS_AD_OFR_RESP_STAT aors,
319: IGS_AD_OFRDFRMT_STAT aods,
320: IGS_PS_ENT_PT_REF_CD ceprc,
321: IGS_GE_REF_CD_TYPE rct
322: WHERE acaiv.person_id = cp_matched_id AND
323: aa.acad_cal_type = p_acad_cal_type AND
324: aa.acad_ci_sequence_number = p_acad_ci_sequence_number AND
325: aods.adm_offer_dfrmnt_status = acaiv.adm_offer_dfrmnt_status AND