DBA Data[Home] [Help]

APPS.IGS_EN_GEN_016 dependencies on IGS_CA_STAT

Line 94: FROM igs_ca_inst ci , igs_ca_type ct , igs_ca_stat cs , igs_ca_inst_rel cir

90: --
91: CURSOR get_load_cal_inst (p_acad_cal_type IN VARCHAR2 , p_acad_ci_sequence_number IN NUMBER ,
92: p_start_dt IN DATE , p_end_dt IN DATE )IS
93: SELECT ci.cal_type , ci.start_dt , ci.end_dt , ci.sequence_number
94: FROM igs_ca_inst ci , igs_ca_type ct , igs_ca_stat cs , igs_ca_inst_rel cir
95: WHERE ct.cal_type = ci.cal_type
96: AND ct.s_cal_cat = 'LOAD'
97: AND cir.sup_cal_type = p_acad_cal_type
98: AND cir.sup_ci_sequence_number = p_acad_ci_sequence_number