APPS.IGS_AD_VAL_ACAI dependencies on IGS_EN_UNIT_SET

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 1667: v_expiry_dt IGS_EN_UNIT_SET.expiry_dt%TYPE;

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;
1671: v_coacus_rec_found BOOLEAN := FALSE;

Line 1673: cp_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE,

1669: v_coousv_match BOOLEAN := FALSE;
1670: v_coacus_match BOOLEAN := FALSE;
1671: v_coacus_rec_found BOOLEAN := FALSE;
1672: CURSOR c_us_uss (
1673: cp_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE,
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,

Line 1674: cp_us_version_number IGS_EN_UNIT_SET.version_number%TYPE) IS

1670: v_coacus_match BOOLEAN := FALSE;
1671: v_coacus_rec_found BOOLEAN := FALSE;
1672: CURSOR c_us_uss (
1673: cp_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE,
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

Line 1677: FROM IGS_EN_UNIT_SET us,

1673: cp_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE,
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

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 1681: FROM igs_en_unit_set_cat usc

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'
1683: OR usc.s_unit_set_cat = 'PRENRL_YR') )
1684: AND us.UNIT_SET_STATUS = uss.UNIT_SET_STATUS
1685: AND us.unit_set_cd = cp_unit_set_cd

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 1727: FROM igs_en_unit_set_cat usc

1723: AND uss.s_unit_set_status <> 'INACTIVE'
1724: )
1725: AND psusv.unit_set_cat IN
1726: (SELECT usc.unit_set_cat
1727: FROM igs_en_unit_set_cat usc
1728: WHERE ((fnd_profile.value ('IGS_PS_PRENRL_YEAR_IND') <> 'Y'
1729: OR usc.s_unit_set_cat = 'PRENRL_YR'))
1730: )
1731: AND psusv.expiry_dt IS NULL

Line 1735: igs_en_unit_set us

1731: AND psusv.expiry_dt IS NULL
1732: UNION
1733: SELECT 1
1734: FROM igs_ps_coo_ad_unit_s psus,
1735: igs_en_unit_set us
1736: WHERE us.unit_set_cd = psus.unit_set_cd
1737: AND us.version_number = psus.us_version_number
1738: AND psus.unit_set_cd = cp_unit_set_cd
1739: AND psus.us_version_number = cp_us_version_number

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

Line 1755: FROM igs_en_unit_set_cat usc

1751: AND uss.s_unit_set_status <> 'INACTIVE'
1752: )
1753: AND us.unit_set_cat IN
1754: (SELECT usc.unit_set_cat
1755: FROM igs_en_unit_set_cat usc
1756: WHERE ((fnd_profile.value ('IGS_PS_PRENRL_YEAR_IND') <> 'Y'
1757: OR usc.s_unit_set_cat = 'PRENRL_YR'))
1758: )
1759: AND us.expiry_dt IS NULL;