APPS.IGS_AD_VAL_ACAI dependencies on IGS_EN_UNIT_SET_STAT

Line 1666: v_s_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;

1662: cst_active CONSTANT VARCHAR2(6) := 'ACTIVE';
1663: cst_yes CONSTANT VARCHAR2(1) := 'Y';
1664: cst_error CONSTANT VARCHAR2(1) := 'E';
1665: cst_warn CONSTANT VARCHAR2(1) := 'W';
1666: v_s_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
1667: v_expiry_dt IGS_EN_UNIT_SET.expiry_dt%TYPE;
1668: v_message_name VARCHAR2(30);
1669: v_coousv_match BOOLEAN := FALSE;
1670: v_coacus_match BOOLEAN := FALSE;

Line 1678: IGS_EN_UNIT_SET_STAT uss

1674: cp_us_version_number IGS_EN_UNIT_SET.version_number%TYPE) IS
1675: SELECT uss.s_unit_set_status,
1676: us.expiry_dt
1677: FROM IGS_EN_UNIT_SET us,
1678: IGS_EN_UNIT_SET_STAT uss
1679: WHERE us.unit_set_cat IN
1680: ( SELECT usc.unit_set_cat
1681: FROM igs_en_unit_set_cat usc
1682: WHERE (fnd_profile.value ('IGS_PS_PRENRL_YEAR_IND' ) <> 'Y'

Line 1721: FROM igs_en_unit_set_stat uss

1717: AND psus.admission_cat = cp_admission_cat
1718: )
1719: AND psusv.UNIT_SET_STATUS IN
1720: (SELECT unit_set_status
1721: FROM igs_en_unit_set_stat uss
1722: WHERE psusv.unit_set_status = uss.unit_set_status
1723: AND uss.s_unit_set_status <> 'INACTIVE'
1724: )
1725: AND psusv.unit_set_cat IN

Line 1749: FROM igs_en_unit_set_stat uss

1745: AND psus.attendance_type = NVL(cp_attendance_type, psus.attendance_type)
1746: AND psus.admission_cat = cp_admission_cat
1747: AND us.unit_set_status IN
1748: (SELECT unit_set_status
1749: FROM igs_en_unit_set_stat uss
1750: WHERE us.unit_set_status = uss.unit_set_status
1751: AND uss.s_unit_set_status <> 'INACTIVE'
1752: )
1753: AND us.unit_set_cat IN