APPS.IGS_EN_GEN_018 dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 422: FROM igs_en_blk_sua_ints sui, igs_ca_teach_to_load_v ttol

418: cp_program_cd igs_ps_ofr_opt.course_cd%TYPE,
419: cp_program_ver_num igs_en_blk_sua_ints.program_ver_num%TYPE) IS
420: SELECT DISTINCT ttol.load_cal_type cal_type, ttol.load_ci_sequence_number
421: seq_num, ttol.load_alternate_code alt_cd,ttol.load_start_dt
422: FROM igs_en_blk_sua_ints sui, igs_ca_teach_to_load_v ttol
423: WHERE batch_id=cp_batch_id
424: AND person_number=cp_person_number
425: AND status_flag IN ('U','R')
426: AND program_cd=cp_program_cd

Line 430: (SELECT MIN(cttol.load_start_dt) FROM igs_ca_teach_to_load_v cttol

426: AND program_cd=cp_program_cd
427: AND program_ver_num=cp_program_ver_num
428: AND ttol.teach_alternate_code=sui.alternate_cd
429: AND ttol.load_start_dt=
430: (SELECT MIN(cttol.load_start_dt) FROM igs_ca_teach_to_load_v cttol
431: WHERE cttol.teach_cal_type=ttol.teach_cal_type
432: AND cttol.teach_ci_sequence_number=ttol.teach_ci_sequence_number)
433: ORDER BY ttol.load_start_dt;
434:

Line 442: FROM igs_ca_teach_to_load_v ttol

438: ) IS
439: SELECT teach_cal_type,
440: teach_ci_sequence_number,
441: teach_alternate_code
442: FROM igs_ca_teach_to_load_v ttol
443: WHERE ttol.load_cal_type=cp_load_cal_type
444: AND ttol.load_ci_sequence_number=cp_load_seq_num;
445:
446: --Fetches the induvidual sua records from the interface table

Line 520: FROM igs_ca_teach_to_load_v ttol

516: WHERE sui.alternate_cd=cal.alternate_code
517: AND batch_id=cp_batch_id
518: AND status_flag IN ('U','R')
519: AND NOT EXISTS(SELECT load_cal_type,load_ci_sequence_number
520: FROM igs_ca_teach_to_load_v ttol
521: WHERE cal.cal_type=ttol.teach_cal_type
522: AND cal.sequence_number=ttol.teach_ci_sequence_number);
523:
524: CURSOR c_batch_desc (cp_batch_id igs_en_blk_sua_ints.batch_id%TYPE) IS