APPS.IGS_PS_CAL_RSR_VAL dependencies on IGS_CA_LOAD_TO_TEACH_V

Line 450: FROM igs_ca_load_to_teach_v

446: ) IS
447: SELECT teach_cal_type,
448: teach_ci_sequence_number,
449: teach_start_dt
450: FROM igs_ca_load_to_teach_v
451: WHERE load_cal_type = p_input_load_cal_type AND
452: load_ci_sequence_number = p_input_load_sequence_number
453: ORDER BY teach_start_dt DESC;
454: cur_load_to_teach_rec cur_load_to_teach%ROWTYPE;

Line 460: FROM igs_ps_unit_ofr_pat uop , igs_ca_load_to_teach_v lteach ,igs_ps_unit_ver_all uv, igs_ps_unit_stat us

456: CURSOR cur_units( p_input_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE,
457: p_input_load_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE ) IS
458: SELECT DISTINCT uop.unit_cd,
459: uop.version_number
460: FROM igs_ps_unit_ofr_pat uop , igs_ca_load_to_teach_v lteach ,igs_ps_unit_ver_all uv, igs_ps_unit_stat us
461: WHERE lteach.load_cal_type = p_input_load_cal_type AND
462: lteach.load_ci_sequence_number = p_input_load_sequence_number AND
463: uop.cal_type = lteach.teach_cal_type AND
464: uop.ci_sequence_number = lteach.teach_ci_sequence_number AND