APPS.IGS_AD_ASSIGN_EVAL_AI_PKG dependencies on IGS_AD_RVGR_EVALTR

Line 311: FROM igs_ad_rvgr_evaltr ev

307: CURSOR c_appl_rev_prof_evaluator(cp_appl_revprof_revgr_id NUMBER) IS
308: SELECT person_id,
309: person_number,
310: evaluation_sequence
311: FROM igs_ad_rvgr_evaltr ev
312: WHERE appl_revprof_revgr_id = cp_appl_revprof_revgr_id
313: ORDER BY evaluation_sequence;
314:
315: l_appl_rev_prof_evaluator_rec c_appl_rev_prof_evaluator%ROWTYPE;

Line 374: person_number igs_ad_rvgr_evaltr.person_number%TYPE,

370:
371: l_max_evaluation_sequence NUMBER;
372:
373: TYPE l_evalexist_record IS RECORD (
374: person_number igs_ad_rvgr_evaltr.person_number%TYPE,
375: evaluation_sequence igs_ad_rvgr_evaltr.evaluation_sequence%TYPE);
376:
377: TYPE l_evalexist_table IS TABLE OF l_evalexist_record INDEX BY BINARY_INTEGER;
378:

Line 375: evaluation_sequence igs_ad_rvgr_evaltr.evaluation_sequence%TYPE);

371: l_max_evaluation_sequence NUMBER;
372:
373: TYPE l_evalexist_record IS RECORD (
374: person_number igs_ad_rvgr_evaltr.person_number%TYPE,
375: evaluation_sequence igs_ad_rvgr_evaltr.evaluation_sequence%TYPE);
376:
377: TYPE l_evalexist_table IS TABLE OF l_evalexist_record INDEX BY BINARY_INTEGER;
378:
379: l_eval_exists l_evalexist_table;