APPS.IGS_AD_ASSIGN_REVIEW_GRP dependencies on IGS_AD_APL_REV_PRF_ALL

Line 35: FROM igs_ad_apl_rev_prf_all

31: -- Cursor to fetch the Review Profile Grouping Code given the
32: -- Review Profile Id
33: CURSOR c_appl_revprof_group_cd(cp_appl_rev_profile_id NUMBER) IS
34: SELECT appl_rev_profile_gr_cd,site_use_code,review_profile_name
35: FROM igs_ad_apl_rev_prf_all
36: WHERE appl_rev_profile_id = cp_appl_rev_profile_id;
37:
38: -- Cursor to fetch the Review Group Id, Review Group Code, given
39: -- the Review Profile Id