APPS.IGS_EN_VAL_SUSA dependencies on IGS_EN_UNIT_SET_STAT

Line 817: igs_en_unit_set_stat uss1,

813:
814: CURSOR c_uso IS
815: SELECT 'X'
816: FROM IGS_PS_OFR_UNIT_SET cous,
817: igs_en_unit_set_stat uss1,
818: IGS_EN_UNIT_SET_ALL US,
819: IGS_EN_STDNT_PS_ATT spa
820: WHERE spa.person_id = p_person_id
821: AND spa.course_cd = p_course_cd

Line 841: igs_en_unit_set_stat uss1,

837: CURSOR c_usoo IS
838: SELECT 'X'
839: FROM IGS_PS_OF_OPT_UNT_ST coous,
840: IGS_EN_UNIT_SET_ALL US,
841: igs_en_unit_set_stat uss1,
842: IGS_EN_STDNT_PS_ATT spa
843: WHERE spa.person_id = p_person_id
844: AND spa.course_cd = p_course_cd
845: AND coous.coo_id = spa.coo_id

Line 1669: v_s_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;

1665: -- expiry date set and the student has previously selected in within the same
1666: -- course attempt.
1667: DECLARE
1668: cst_active CONSTANT VARCHAR2(6) := 'ACTIVE';
1669: v_s_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
1670: v_expiry_dt IGS_EN_UNIT_SET.expiry_dt%TYPE;
1671: v_dummy VARCHAR2(1);
1672: CURSOR c_us_uss IS
1673: SELECT uss.s_unit_set_status,

Line 1676: IGS_EN_UNIT_SET_STAT uss

1672: CURSOR c_us_uss IS
1673: SELECT uss.s_unit_set_status,
1674: us.expiry_dt
1675: FROM IGS_EN_UNIT_SET us,
1676: IGS_EN_UNIT_SET_STAT uss
1677: WHERE us.unit_set_status = uss.unit_set_status AND
1678: us.unit_set_cd = p_unit_set_cd AND
1679: us.version_number = p_version_number;
1680: CURSOR c_susa IS