APPS.IGS_AD_GEN_010 dependencies on IGS_EN_UNIT_SET

Line 79: v_unit_set_cd IGS_EN_UNIT_SET.unit_set_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';
83: CURSOR c_ceprc IS

Line 80: v_us_version_number IGS_EN_UNIT_SET.version_number%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';
83: CURSOR c_ceprc IS
84: SELECT ceprc.course_cd,

Line 110: FROM IGS_EN_UNIT_SET us,

106: cs.s_course_status = cst_active AND
107: (ceprc.unit_set_cd IS NULL OR
108: EXISTS (
109: SELECT 'x'
110: FROM IGS_EN_UNIT_SET us,
111: IGS_EN_UNIT_SET_STAT uss
112: WHERE us.unit_set_cd = ceprc.unit_set_cd AND
113: us.version_number = ceprc.us_version_number AND
114: expiry_dt IS NULL AND

Line 111: IGS_EN_UNIT_SET_STAT uss

107: (ceprc.unit_set_cd IS NULL OR
108: EXISTS (
109: SELECT 'x'
110: FROM IGS_EN_UNIT_SET us,
111: IGS_EN_UNIT_SET_STAT uss
112: WHERE us.unit_set_cd = ceprc.unit_set_cd AND
113: us.version_number = ceprc.us_version_number AND
114: expiry_dt IS NULL AND
115: uss.unit_set_status = us.unit_set_status AND

Line 276: FROM IGS_EN_UNIT_SET us,

272: cs.s_course_status = cst_active AND
273: (ceprc.unit_set_cd IS NULL OR
274: EXISTS (
275: SELECT 'x'
276: FROM IGS_EN_UNIT_SET us,
277: IGS_EN_UNIT_SET_STAT uss
278: WHERE us.unit_set_cd = ceprc.unit_set_cd AND
279: us.version_number = ceprc.us_version_number AND
280: expiry_dt IS NULL AND

Line 277: IGS_EN_UNIT_SET_STAT uss

273: (ceprc.unit_set_cd IS NULL OR
274: EXISTS (
275: SELECT 'x'
276: FROM IGS_EN_UNIT_SET us,
277: IGS_EN_UNIT_SET_STAT uss
278: WHERE us.unit_set_cd = ceprc.unit_set_cd AND
279: us.version_number = ceprc.us_version_number AND
280: expiry_dt IS NULL AND
281: uss.unit_set_status = us.unit_set_status AND