APPS.IGS_AV_GEN_001 dependencies on IGS_AV_STD_UNT_BASIS_ALL

Line 94: CURSOR c_unit_basis_all(cp_unit_id IGS_AV_STD_UNT_BASIS_ALL.av_stnd_unit_id%TYPE) IS

90: FROM IGS_AV_STND_UNIT_LVL_ALL aslvl
91: WHERE aslvl.person_id = p_person_id AND
92: aslvl.as_course_cd = p_course_cd;
93:
94: CURSOR c_unit_basis_all(cp_unit_id IGS_AV_STD_UNT_BASIS_ALL.av_stnd_unit_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:

Line 96: FROM IGS_AV_STD_UNT_BASIS_ALL asba

92: aslvl.as_course_cd = p_course_cd;
93:
94: CURSOR c_unit_basis_all(cp_unit_id IGS_AV_STD_UNT_BASIS_ALL.av_stnd_unit_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

Line 1931: not exists ( select 1 from IGS_AV_STD_UNT_BASIS_ALL basis where basis.AV_STND_UNIT_ID= unt.AV_STND_UNIT_ID) ;

1927: select AV_STND_UNIT_ID from IGS_AV_STND_UNIT_ALL unt where
1928: person_id =p_person_id and
1929: as_course_cd = p_course_cd and
1930: as_version_number = p_version_number and
1931: not exists ( select 1 from IGS_AV_STD_UNT_BASIS_ALL basis where basis.AV_STND_UNIT_ID= unt.AV_STND_UNIT_ID) ;
1932:
1933: CURSOR C_AV_UNT_LVL is
1934: select AV_STND_UNIT_LVL_ID from IGS_AV_STND_UNIT_LVL_ALL ulvl where
1935: person_id =p_person_id and