APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 677: FROM igs_ca_teach_to_load_v a,

673: CURSOR c_anon_grd_method ( cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
674: cp_ci_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
675: cp_load_start_dt igs_ca_inst_all.start_dt%TYPE) IS
676: SELECT 1
677: FROM igs_ca_teach_to_load_v a,
678: igs_as_anon_method b
679: WHERE a.teach_cal_type = cp_cal_type
680: AND a.teach_ci_sequence_number = cp_ci_seq_num
681: AND a.load_start_dt = cp_load_start_dt

Line 688: FROM igs_ca_teach_to_load_v c

684:
685: CURSOR c_min_load_start_dt ( cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
686: cp_ci_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE ) IS
687: SELECT MIN(c.load_start_dt)
688: FROM igs_ca_teach_to_load_v c
689: WHERE c.teach_cal_type = cp_cal_type
690: AND c.teach_ci_sequence_number = cp_ci_seq_num ;
691:
692: l_load_start_dt igs_ca_inst_all.start_dt%TYPE;

Line 762: FROM igs_ca_teach_to_load_v

758:
759:
760: CURSOR cur_teach_load IS
761: SELECT load_cal_type,load_ci_sequence_number
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,

Line 776: FROM igs_ca_teach_to_load_v

772:
773: CURSOR c_teach_to_load ( cp_cal_type igs_ca_type.cal_type%TYPE,
774: cp_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
775: SELECT load_cal_type lcal_type, load_ci_sequence_number lseq_num
776: FROM igs_ca_teach_to_load_v
777: WHERE
778: teach_cal_type = cp_cal_type AND
779: teach_ci_sequence_number = cp_seq_num;
780: rec_teach_to_load c_teach_to_load%ROWTYPE;