APPS.IGS_AD_ASSIGN_EVAL_AI_PKG dependencies on IGS_AD_APL_REV_PRF_ALL

Line 317: CURSOR c_seq_conc_ind (cp_appl_rev_profile_id igs_ad_apl_rev_prf_all.APPL_REV_PROFILE_ID%TYPE) IS

313: ORDER BY evaluation_sequence;
314:
315: l_appl_rev_prof_evaluator_rec c_appl_rev_prof_evaluator%ROWTYPE;
316:
317: CURSOR c_seq_conc_ind (cp_appl_rev_profile_id igs_ad_apl_rev_prf_all.APPL_REV_PROFILE_ID%TYPE) IS
318: SELECT sequential_concurrent_ind
319: FROM igs_ad_apl_rev_prf_all
320: WHERE APPL_REV_PROFILE_ID = cp_appl_rev_profile_id;
321:

Line 319: FROM igs_ad_apl_rev_prf_all

315: l_appl_rev_prof_evaluator_rec c_appl_rev_prof_evaluator%ROWTYPE;
316:
317: CURSOR c_seq_conc_ind (cp_appl_rev_profile_id igs_ad_apl_rev_prf_all.APPL_REV_PROFILE_ID%TYPE) IS
318: SELECT sequential_concurrent_ind
319: FROM igs_ad_apl_rev_prf_all
320: WHERE APPL_REV_PROFILE_ID = cp_appl_rev_profile_id;
321:
322: l_seq_conc_ind igs_ad_apl_rev_prf_all.sequential_concurrent_ind%TYPE;
323:

Line 322: l_seq_conc_ind igs_ad_apl_rev_prf_all.sequential_concurrent_ind%TYPE;

318: SELECT sequential_concurrent_ind
319: FROM igs_ad_apl_rev_prf_all
320: WHERE APPL_REV_PROFILE_ID = cp_appl_rev_profile_id;
321:
322: l_seq_conc_ind igs_ad_apl_rev_prf_all.sequential_concurrent_ind%TYPE;
323:
324: CURSOR c_arp_rate_scale(cp_appl_rev_profile_id number) IS
325: SELECT *
326: FROM igs_ad_apl_rvpf_rsl arr

Line 850: igs_ad_apl_rev_prf_all

846: cp_sequence_number igs_ad_appl_arp.sequence_number%TYPE) IS
847: SELECT
848: distinct sequential_concurrent_ind
849: FROM
850: igs_ad_apl_rev_prf_all
851: WHERE
852: appl_rev_profile_id = (select appl_rev_profile_id
853: from igs_ad_appl_arp
854: where person_id = cp_person_id

Line 889: l_exist_eval_type igs_ad_apl_rev_prf_all.sequential_concurrent_ind%TYPE;

885: AND sequence_number = cp_seq_number
886: AND evaluator_id = cp_evaluator_id;
887:
888: l_next_seq c_next_seq%ROWTYPE;
889: l_exist_eval_type igs_ad_apl_rev_prf_all.sequential_concurrent_ind%TYPE;
890: l_exist_arp_id igs_ad_appl_arp_v.appl_rev_profile_id%TYPE;
891: l_count igs_ad_appl_eval.evaluation_sequence%TYPE;
892: l_max_evaluation_sequence igs_ad_appl_eval.evaluation_sequence%TYPE;
893: l_chk_rating_val_null VARCHAR2(1);