APPS.IGS_AD_VAL_ACAI dependencies on IGS_PS_OF_UNT_SET_RL

Line 1953: -- IGS_PS_OF_UNT_SET_RL table.

1949: -- This module validates that a crs_adm_cat_unit_set record can only be
1950: -- created when:
1951: -- . the IGS_PS_OFR_UNIT_SET.only_as_sub_ind = 'N' and
1952: -- . the IGS_PS_OFR_UNIT_SET does not exist as a subordinate in the
1953: -- IGS_PS_OF_UNT_SET_RL table.
1954: DECLARE
1955: v_dummy VARCHAR2(1);
1956: CURSOR c_cousr IS
1957: SELECT 'x'

Line 1958: FROM IGS_PS_OF_UNT_SET_RL cousr

1954: DECLARE
1955: v_dummy VARCHAR2(1);
1956: CURSOR c_cousr IS
1957: SELECT 'x'
1958: FROM IGS_PS_OF_UNT_SET_RL cousr
1959: WHERE cousr.course_cd = p_course_cd AND
1960: cousr.crv_version_number = p_crv_version_number AND
1961: cousr.cal_type = p_cal_type AND
1962: cousr.sub_unit_set_cd = p_unit_set_cd AND