APPS.IGS_AV_GEN_001 dependencies on IGS_AV_STD_ULVLBASIS_ALL

Line 99: CURSOR c_ulvlbasis_all(cp_unit_lvl_id IGS_AV_STD_ULVLBASIS_ALL.av_stnd_unit_lvl_id%TYPE) IS

95: SELECT rowid
96: FROM IGS_AV_STD_UNT_BASIS_ALL asba
97: WHERE asba.av_stnd_unit_id = cp_unit_id;
98:
99: CURSOR c_ulvlbasis_all(cp_unit_lvl_id IGS_AV_STD_ULVLBASIS_ALL.av_stnd_unit_lvl_id%TYPE) IS
100: SELECT rowid
101: FROM IGS_AV_STD_ULVLBASIS_ALL asbl
102: WHERE asbl.av_stnd_unit_lvl_id = cp_unit_lvl_id;
103:

Line 101: FROM IGS_AV_STD_ULVLBASIS_ALL asbl

97: WHERE asba.av_stnd_unit_id = cp_unit_id;
98:
99: CURSOR c_ulvlbasis_all(cp_unit_lvl_id IGS_AV_STD_ULVLBASIS_ALL.av_stnd_unit_lvl_id%TYPE) IS
100: SELECT rowid
101: FROM IGS_AV_STD_ULVLBASIS_ALL asbl
102: WHERE asbl.av_stnd_unit_lvl_id = cp_unit_lvl_id;
103:
104: CURSOR c_alt_unt_all(cp_alt_unit_id IGS_AV_STND_ALT_UNIT.av_stnd_unit_id%TYPE) IS
105: SELECT rowid

Line 1938: not exists ( select 1 from IGS_AV_STD_ULVLBASIS_ALL basis where basis.AV_STND_UNIT_LVL_ID= ulvl.AV_STND_UNIT_LVL_ID) ;

1934: select AV_STND_UNIT_LVL_ID from IGS_AV_STND_UNIT_LVL_ALL ulvl where
1935: person_id =p_person_id and
1936: as_course_cd = p_course_cd and
1937: as_version_number = p_version_number and
1938: not exists ( select 1 from IGS_AV_STD_ULVLBASIS_ALL basis where basis.AV_STND_UNIT_LVL_ID= ulvl.AV_STND_UNIT_LVL_ID) ;
1939:
1940: lv_rowid VARCHAR2(25);
1941:
1942: BEGIN