APPS.IGS_EN_GEN_LEGACY dependencies on IGS_EN_UNIT_SET

Line 1532: igs_en_unit_set us,

1528: CURSOR c_prenrol_unitset IS
1529: SELECT
1530: 'x'
1531: FROM
1532: igs_en_unit_set us,
1533: igs_en_unit_set_cat usc
1534: WHERE
1535: us.unit_set_cd = p_unit_set_cd
1536: AND us.version_number = p_us_version_number

Line 1533: igs_en_unit_set_cat usc

1529: SELECT
1530: 'x'
1531: FROM
1532: igs_en_unit_set us,
1533: igs_en_unit_set_cat usc
1534: WHERE
1535: us.unit_set_cd = p_unit_set_cd
1536: AND us.version_number = p_us_version_number
1537: AND us.unit_set_cat = usc.unit_set_cat

Line 1599: FROM igs_en_unit_set us,

1595:
1596: CURSOR c_us_cat (cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE,
1597: cp_us_version_number igs_as_su_setatmpt.us_version_number%TYPE) IS
1598: SELECT usc.s_unit_set_cat
1599: FROM igs_en_unit_set us,
1600: igs_en_unit_set_cat usc
1601: WHERE us.unit_set_cd = cp_unit_set_cd
1602: AND us.version_number = cp_us_version_number
1603: AND us.unit_set_cat = usc.unit_set_cat;

Line 1600: igs_en_unit_set_cat usc

1596: CURSOR c_us_cat (cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE,
1597: cp_us_version_number igs_as_su_setatmpt.us_version_number%TYPE) IS
1598: SELECT usc.s_unit_set_cat
1599: FROM igs_en_unit_set us,
1600: igs_en_unit_set_cat usc
1601: WHERE us.unit_set_cd = cp_unit_set_cd
1602: AND us.version_number = cp_us_version_number
1603: AND us.unit_set_cat = usc.unit_set_cat;
1604:

Line 1611: igs_en_unit_set us,

1607: SELECT
1608: 'x'
1609: FROM
1610: igs_as_su_setatmpt asu,
1611: igs_en_unit_set us,
1612: igs_en_unit_set_cat usc
1613: WHERE
1614: asu.person_id = p_person_id
1615: AND asu.course_cd = p_program_cd

Line 1612: igs_en_unit_set_cat usc

1608: 'x'
1609: FROM
1610: igs_as_su_setatmpt asu,
1611: igs_en_unit_set us,
1612: igs_en_unit_set_cat usc
1613: WHERE
1614: asu.person_id = p_person_id
1615: AND asu.course_cd = p_program_cd
1616: AND asu.unit_set_cd = us.unit_set_cd

Line 1627: l_s_unit_set_cat igs_en_unit_set_cat.s_unit_set_cat%TYPE;

1623: AND NVL (asu.rqrmnts_complete_dt,NVL(asu.end_dt,(TO_DATE('9999/12/31','YYYY/MM/DD'))))))
1624: AND ((p_sequence_number IS NULL) OR (asu.sequence_number <> p_sequence_number));
1625:
1626: l_dummy VARCHAR2(1);
1627: l_s_unit_set_cat igs_en_unit_set_cat.s_unit_set_cat%TYPE;
1628: BEGIN
1629:
1630: -- check if the passed in unit set is a pre-enrollment year unit set
1631: -- if the passed in unit set is not a pre-enr unit set then return true