APPS.IGS_AD_ASSIGN_EVAL_AI_PKG dependencies on IGS_AD_APL_RPRF_RGR

Line 32: l_appl_revprof_revgr_id igs_ad_apl_rprf_rgr.appl_revprof_revgr_id%TYPE;

28:
29: INVALID_PARAMETER EXCEPTION;
30:
31: l_rating_exists VARCHAR2(1);
32: l_appl_revprof_revgr_id igs_ad_apl_rprf_rgr.appl_revprof_revgr_id%TYPE;
33:
34:
35: CURSOR c_common_no_eval(cp_review_profile_id igs_ad_appl_arp.appl_rev_profile_id%TYPE,
36: cp_appl_revprof_revgr_id igs_ad_appl_arp.appl_revprof_revgr_id%TYPE) IS

Line 127: CURSOR c_appl_rev_group (cp_review_group_code igs_ad_apl_rprf_rgr.revprof_revgr_cd%TYPE) IS

123: WHERE appl_rev_profile_id = cp_appl_rev_profile_id;
124:
125: l_review_profile_name igs_ad_apl_rev_prf.review_profile_name%TYPE;
126:
127: CURSOR c_appl_rev_group (cp_review_group_code igs_ad_apl_rprf_rgr.revprof_revgr_cd%TYPE) IS
128: SELECT revprof_revgr_cd
129: FROM igs_ad_apl_rprf_rgr
130: WHERE appl_revprof_revgr_id = cp_review_group_code;
131:

Line 129: FROM igs_ad_apl_rprf_rgr

125: l_review_profile_name igs_ad_apl_rev_prf.review_profile_name%TYPE;
126:
127: CURSOR c_appl_rev_group (cp_review_group_code igs_ad_apl_rprf_rgr.revprof_revgr_cd%TYPE) IS
128: SELECT revprof_revgr_cd
129: FROM igs_ad_apl_rprf_rgr
130: WHERE appl_revprof_revgr_id = cp_review_group_code;
131:
132: l_review_group_code igs_ad_apl_rprf_rgr.revprof_revgr_cd%TYPE;
133:

Line 132: l_review_group_code igs_ad_apl_rprf_rgr.revprof_revgr_cd%TYPE;

128: SELECT revprof_revgr_cd
129: FROM igs_ad_apl_rprf_rgr
130: WHERE appl_revprof_revgr_id = cp_review_group_code;
131:
132: l_review_group_code igs_ad_apl_rprf_rgr.revprof_revgr_cd%TYPE;
133:
134: l_unassigned_appl VARCHAR2(3);
135:
136: BEGIN