APPS.IGS_AS_GEN_001 dependencies on IGS_AS_EXM_INS_SPVSR

Line 36: v_exam_cal_type igs_as_exm_ins_spvsr.exam_cal_type%TYPE;

32: -- sessions supervised prior to the current date.
33: DECLARE
34: v_sysdate DATE;
35: v_session_count NUMBER := 0;
36: v_exam_cal_type igs_as_exm_ins_spvsr.exam_cal_type%TYPE;
37: v_exam_ci_seq_num igs_as_exm_ins_spvsr.exam_ci_sequence_number%TYPE;
38: v_dt_alias igs_as_exm_ins_spvsr.dt_alias%TYPE;
39: v_dai_seq_num igs_as_exm_ins_spvsr.dai_sequence_number%TYPE;
40: v_start_time igs_as_exm_ins_spvsr.start_time%TYPE;

Line 37: v_exam_ci_seq_num igs_as_exm_ins_spvsr.exam_ci_sequence_number%TYPE;

33: DECLARE
34: v_sysdate DATE;
35: v_session_count NUMBER := 0;
36: v_exam_cal_type igs_as_exm_ins_spvsr.exam_cal_type%TYPE;
37: v_exam_ci_seq_num igs_as_exm_ins_spvsr.exam_ci_sequence_number%TYPE;
38: v_dt_alias igs_as_exm_ins_spvsr.dt_alias%TYPE;
39: v_dai_seq_num igs_as_exm_ins_spvsr.dai_sequence_number%TYPE;
40: v_start_time igs_as_exm_ins_spvsr.start_time%TYPE;
41: v_end_time igs_as_exm_ins_spvsr.end_time%TYPE;

Line 38: v_dt_alias igs_as_exm_ins_spvsr.dt_alias%TYPE;

34: v_sysdate DATE;
35: v_session_count NUMBER := 0;
36: v_exam_cal_type igs_as_exm_ins_spvsr.exam_cal_type%TYPE;
37: v_exam_ci_seq_num igs_as_exm_ins_spvsr.exam_ci_sequence_number%TYPE;
38: v_dt_alias igs_as_exm_ins_spvsr.dt_alias%TYPE;
39: v_dai_seq_num igs_as_exm_ins_spvsr.dai_sequence_number%TYPE;
40: v_start_time igs_as_exm_ins_spvsr.start_time%TYPE;
41: v_end_time igs_as_exm_ins_spvsr.end_time%TYPE;
42: --

Line 39: v_dai_seq_num igs_as_exm_ins_spvsr.dai_sequence_number%TYPE;

35: v_session_count NUMBER := 0;
36: v_exam_cal_type igs_as_exm_ins_spvsr.exam_cal_type%TYPE;
37: v_exam_ci_seq_num igs_as_exm_ins_spvsr.exam_ci_sequence_number%TYPE;
38: v_dt_alias igs_as_exm_ins_spvsr.dt_alias%TYPE;
39: v_dai_seq_num igs_as_exm_ins_spvsr.dai_sequence_number%TYPE;
40: v_start_time igs_as_exm_ins_spvsr.start_time%TYPE;
41: v_end_time igs_as_exm_ins_spvsr.end_time%TYPE;
42: --
43: CURSOR c_ese IS

Line 40: v_start_time igs_as_exm_ins_spvsr.start_time%TYPE;

36: v_exam_cal_type igs_as_exm_ins_spvsr.exam_cal_type%TYPE;
37: v_exam_ci_seq_num igs_as_exm_ins_spvsr.exam_ci_sequence_number%TYPE;
38: v_dt_alias igs_as_exm_ins_spvsr.dt_alias%TYPE;
39: v_dai_seq_num igs_as_exm_ins_spvsr.dai_sequence_number%TYPE;
40: v_start_time igs_as_exm_ins_spvsr.start_time%TYPE;
41: v_end_time igs_as_exm_ins_spvsr.end_time%TYPE;
42: --
43: CURSOR c_ese IS
44: SELECT DISTINCT eis.exam_cal_type,

Line 41: v_end_time igs_as_exm_ins_spvsr.end_time%TYPE;

37: v_exam_ci_seq_num igs_as_exm_ins_spvsr.exam_ci_sequence_number%TYPE;
38: v_dt_alias igs_as_exm_ins_spvsr.dt_alias%TYPE;
39: v_dai_seq_num igs_as_exm_ins_spvsr.dai_sequence_number%TYPE;
40: v_start_time igs_as_exm_ins_spvsr.start_time%TYPE;
41: v_end_time igs_as_exm_ins_spvsr.end_time%TYPE;
42: --
43: CURSOR c_ese IS
44: SELECT DISTINCT eis.exam_cal_type,
45: eis.exam_ci_sequence_number,

Line 50: FROM igs_as_exm_ins_spvsr eis,

46: eis.dt_alias,
47: eis.dai_sequence_number,
48: eis.start_time,
49: eis.end_time
50: FROM igs_as_exm_ins_spvsr eis,
51: igs_as_exam_session_v esev
52: WHERE eis.person_id = p_person_id
53: AND eis.exam_cal_type = esev.exam_cal_type
54: AND eis.exam_ci_sequence_number = esev.exam_ci_sequence_number