DBA Data[Home] [Help]

APPS.IGS_PS_UNIT_OFR_OPT_PKG dependencies on IGS_CA_LOAD_TO_TEACH_V

Line 548: CURSOR cur_load_teach(cp_cal_type igs_ca_load_to_teach_v.load_cal_type%TYPE,

544: FROM igs_ca_teach_to_load_v
545: WHERE teach_cal_type=cp_cal_type
546: AND teach_ci_sequence_number=cp_sequence_number;
547:
548: CURSOR cur_load_teach(cp_cal_type igs_ca_load_to_teach_v.load_cal_type%TYPE,
549: cp_sequence_number igs_ca_load_to_teach_v.load_ci_sequence_number%TYPE) IS
550: SELECT teach_cal_type,teach_ci_sequence_number
551: FROM igs_ca_load_to_teach_v
552: WHERE load_cal_type=cp_cal_type

Line 549: cp_sequence_number igs_ca_load_to_teach_v.load_ci_sequence_number%TYPE) IS

545: WHERE teach_cal_type=cp_cal_type
546: AND teach_ci_sequence_number=cp_sequence_number;
547:
548: CURSOR cur_load_teach(cp_cal_type igs_ca_load_to_teach_v.load_cal_type%TYPE,
549: cp_sequence_number igs_ca_load_to_teach_v.load_ci_sequence_number%TYPE) IS
550: SELECT teach_cal_type,teach_ci_sequence_number
551: FROM igs_ca_load_to_teach_v
552: WHERE load_cal_type=cp_cal_type
553: AND load_ci_sequence_number=cp_sequence_number;

Line 551: FROM igs_ca_load_to_teach_v

547:
548: CURSOR cur_load_teach(cp_cal_type igs_ca_load_to_teach_v.load_cal_type%TYPE,
549: cp_sequence_number igs_ca_load_to_teach_v.load_ci_sequence_number%TYPE) IS
550: SELECT teach_cal_type,teach_ci_sequence_number
551: FROM igs_ca_load_to_teach_v
552: WHERE load_cal_type=cp_cal_type
553: AND load_ci_sequence_number=cp_sequence_number;
554:
555: CURSOR cur_detail (cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,