APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_CA_LOAD_TO_TEACH_V

Line 766: CURSOR c_cal_rel(cp_cal_teach_type igs_ca_load_to_teach_v.teach_cal_type%TYPE,

762: FROM igs_ca_teach_to_load_v
763: WHERE teach_cal_type=p_c_cal_type
764: AND teach_ci_sequence_number=p_n_seq_num;
765:
766: CURSOR c_cal_rel(cp_cal_teach_type igs_ca_load_to_teach_v.teach_cal_type%TYPE,
767: cp_teach_ci_sequence_number igs_ca_load_to_teach_v.teach_ci_sequence_number%TYPE) IS
768: SELECT load_cal_type,load_ci_sequence_number
769: FROM igs_ca_load_to_teach_v
770: WHERE teach_cal_type = cp_cal_teach_type

Line 767: cp_teach_ci_sequence_number igs_ca_load_to_teach_v.teach_ci_sequence_number%TYPE) IS

763: WHERE teach_cal_type=p_c_cal_type
764: AND teach_ci_sequence_number=p_n_seq_num;
765:
766: CURSOR c_cal_rel(cp_cal_teach_type igs_ca_load_to_teach_v.teach_cal_type%TYPE,
767: cp_teach_ci_sequence_number igs_ca_load_to_teach_v.teach_ci_sequence_number%TYPE) IS
768: SELECT load_cal_type,load_ci_sequence_number
769: FROM igs_ca_load_to_teach_v
770: WHERE teach_cal_type = cp_cal_teach_type
771: AND teach_ci_sequence_number = cp_teach_ci_sequence_number;

Line 769: FROM igs_ca_load_to_teach_v

765:
766: CURSOR c_cal_rel(cp_cal_teach_type igs_ca_load_to_teach_v.teach_cal_type%TYPE,
767: cp_teach_ci_sequence_number igs_ca_load_to_teach_v.teach_ci_sequence_number%TYPE) IS
768: SELECT load_cal_type,load_ci_sequence_number
769: FROM igs_ca_load_to_teach_v
770: WHERE teach_cal_type = cp_cal_teach_type
771: AND teach_ci_sequence_number = cp_teach_ci_sequence_number;
772:
773: CURSOR c_teach_to_load ( cp_cal_type igs_ca_type.cal_type%TYPE,

Line 2753: igs_ca_load_to_teach_v lot

2749: CURSOR c_waitlist_allowed ( cp_c_cal_type igs_ca_type.cal_type%TYPE,
2750: cp_n_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
2751: SELECT inst.waitlist_alwd
2752: FROM igs_en_inst_wlst_opt inst,
2753: igs_ca_load_to_teach_v lot
2754: WHERE
2755: inst.cal_type = lot.load_cal_type AND
2756: lot.teach_cal_type = cp_c_cal_type AND
2757: lot.teach_ci_sequence_number = cp_n_seq_num;