APPS.IGS_EN_VAL_SCA dependencies on IGS_EN_DCNT_REASONCD

Line 1704: || Purpose : validate the IGS_EN_DCNT_REASONCD from the IGS_EN_STDNT_PS_ATT table

1700: RETURN BOOLEAN AS
1701: /*----------------------------------------------------------------------------
1702: || Created By :
1703: || Created On :
1704: || Purpose : validate the IGS_EN_DCNT_REASONCD from the IGS_EN_STDNT_PS_ATT table
1705: ||
1706: || Known limitations, enhancements or remarks :
1707: || Change History :
1708: || Who When What

Line 1727: FROM IGS_EN_DCNT_REASONCD dr

1723: v_dummy VARCHAR2(1);
1724: CURSOR c_sca IS
1725: SELECT dr.closed_ind,
1726: dr.s_discontinuation_reason_type
1727: FROM IGS_EN_DCNT_REASONCD dr
1728: WHERE dr.discontinuation_reason_cd = p_discontinuation_reason_cd;
1729:
1730: -- Modifed cursor to consider the status_flag while finding the transfer records
1731: CURSOR c_sct IS

Line 1867: || Purpose : Validate the IGS_EN_DCNT_REASONCD and discontinued_dt

1863: RETURN BOOLEAN AS
1864: /*----------------------------------------------------------------------------
1865: || Created By :
1866: || Created On :
1867: || Purpose : Validate the IGS_EN_DCNT_REASONCD and discontinued_dt
1868: || from the IGS_EN_STDNT_PS_ATT :
1869: || * If the discontinuation_reason code is set it must not be closed
1870: || * If both discontinued_dt and commencement_dt are set then
1871: || discontinued_dt must be >= commencement_dt