APPS.IGS_EN_GEN_011 dependencies on IGS_PS_OFR_OPT_UNIT_SET_V

Line 380: cp_unit_set_cd IGS_PS_OFR_OPT_UNIT_SET_V.unit_set_cd%TYPE,

376: susa.student_confirmed_ind = 'Y' AND
377: susa.end_dt IS NULL;
378: -- modified cursor for perf bug 3696293 : sql id : 14791636
379: CURSOR c_coousv (
380: cp_unit_set_cd IGS_PS_OFR_OPT_UNIT_SET_V.unit_set_cd%TYPE,
381: cp_us_version_number IGS_PS_OFR_OPT_UNIT_SET_V.us_version_number%TYPE,
382: cp_coo_id IGS_PS_OFR_OPT_UNIT_SET_V.coo_id%TYPE) IS
383: SELECT 'x' FROM
384: IGS_PS_OFR_UNIT_SET cous,

Line 381: cp_us_version_number IGS_PS_OFR_OPT_UNIT_SET_V.us_version_number%TYPE,

377: susa.end_dt IS NULL;
378: -- modified cursor for perf bug 3696293 : sql id : 14791636
379: CURSOR c_coousv (
380: cp_unit_set_cd IGS_PS_OFR_OPT_UNIT_SET_V.unit_set_cd%TYPE,
381: cp_us_version_number IGS_PS_OFR_OPT_UNIT_SET_V.us_version_number%TYPE,
382: cp_coo_id IGS_PS_OFR_OPT_UNIT_SET_V.coo_id%TYPE) IS
383: SELECT 'x' FROM
384: IGS_PS_OFR_UNIT_SET cous,
385: IGS_PS_OFR_OPT coo

Line 382: cp_coo_id IGS_PS_OFR_OPT_UNIT_SET_V.coo_id%TYPE) IS

378: -- modified cursor for perf bug 3696293 : sql id : 14791636
379: CURSOR c_coousv (
380: cp_unit_set_cd IGS_PS_OFR_OPT_UNIT_SET_V.unit_set_cd%TYPE,
381: cp_us_version_number IGS_PS_OFR_OPT_UNIT_SET_V.us_version_number%TYPE,
382: cp_coo_id IGS_PS_OFR_OPT_UNIT_SET_V.coo_id%TYPE) IS
383: SELECT 'x' FROM
384: IGS_PS_OFR_UNIT_SET cous,
385: IGS_PS_OFR_OPT coo
386: WHERE