APPS.IGS_AD_GEN_014 dependencies on IGS_EN_UNIT_SET_STAT

Line 1518: v_s_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;

1514: cst_active CONSTANT VARCHAR2(6) := 'ACTIVE';
1515: cst_yes CONSTANT VARCHAR2(1) := 'Y';
1516: cst_error CONSTANT VARCHAR2(1) := 'E';
1517: cst_warn CONSTANT VARCHAR2(1) := 'W';
1518: v_s_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
1519: v_expiry_dt IGS_EN_UNIT_SET.expiry_dt%TYPE;
1520: v_message_name VARCHAR2(30);
1521: v_coousv_match BOOLEAN DEFAULT FALSE;
1522: v_coacus_match BOOLEAN DEFAULT FALSE;

Line 1531: IGS_EN_UNIT_SET_STAT uss

1527: cp_us_version_number IGS_EN_UNIT_SET.version_number%TYPE) IS
1528: SELECT uss.s_unit_set_status,
1529: us.expiry_dt
1530: FROM IGS_EN_UNIT_SET us,
1531: IGS_EN_UNIT_SET_STAT uss
1532: WHERE us.unit_set_cat IN
1533: ( SELECT usc.unit_set_cat
1534: FROM igs_en_unit_set_cat usc
1535: WHERE (fnd_profile.value ('IGS_PS_PRENRL_YEAR_IND' ) <> 'Y'

Line 1575: FROM igs_en_unit_set_stat uss

1571: AND psus.admission_cat = cp_admission_cat
1572: )
1573: AND psusv.UNIT_SET_STATUS IN
1574: (SELECT unit_set_status
1575: FROM igs_en_unit_set_stat uss
1576: WHERE psusv.unit_set_status = uss.unit_set_status
1577: AND uss.s_unit_set_status <> 'INACTIVE'
1578: )
1579: AND psusv.unit_set_cat IN

Line 1603: FROM igs_en_unit_set_stat uss

1599: AND psus.attendance_type = NVL(cp_attendance_type, psus.attendance_type)
1600: AND psus.admission_cat = cp_admission_cat
1601: AND us.unit_set_status IN
1602: (SELECT unit_set_status
1603: FROM igs_en_unit_set_stat uss
1604: WHERE us.unit_set_status = uss.unit_set_status
1605: AND uss.s_unit_set_status <> 'INACTIVE'
1606: )
1607: AND us.unit_set_cat IN