DBA Data[Home] [Help]

APPS.IGS_EN_GEN_011 dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 1424: FROM igs_ca_teach_to_load_v

1420: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE,
1421: cp_load_cal_type igs_ca_inst.cal_type%TYPE,
1422: cp_load_seq_num igs_ca_inst.sequence_number%TYPE) IS
1423: SELECT '1'
1424: FROM igs_ca_teach_to_load_v
1425: WHERE teach_cal_type = cp_teach_cal_type
1426: AND teach_ci_sequence_number = cp_teach_seq_num
1427: AND load_cal_type = cp_load_cal_type
1428: AND load_ci_sequence_number = cp_load_seq_num;

Line 2863: FROM igs_ca_teach_to_load_v tl,

2859: --Cursor to get the load calendar for a given teach calendar
2860: CURSOR cur_load1 IS
2861: SELECT tl.load_cal_type ,
2862: tl.load_ci_sequence_number
2863: FROM igs_ca_teach_to_load_v tl,
2864: IGS_CA_INST ci,
2865: IGS_CA_STAT cs
2866: WHERE tl.teach_cal_type = p_teach_cal_type
2867: AND tl.teach_ci_sequence_number = p_teach_ci_sequence_number