APPS.IGS_SS_ENROLL_PKG dependencies on IGS_CA_STAT

Line 577: igs_ca_stat cs

573: SELECT ci.sequence_number||ci.cal_type
574: FROM igs_ca_inst ci,
575: igs_ca_inst_rel cir,
576: igs_ca_type ct,
577: igs_ca_stat cs
578: WHERE ci.cal_type = cir.sub_cal_type AND
579: ci.sequence_number = cir.sub_ci_sequence_number AND
580: ci.cal_type = ct.cal_type AND
581: ct.s_cal_cat = 'LOAD' AND

Line 687: igs_ca_stat cs

683: SELECT ci.start_dt
684: FROM igs_ca_inst ci,
685: igs_ca_inst_rel cir,
686: igs_ca_type ct,
687: igs_ca_stat cs
688: WHERE ci.cal_type = cir.sub_cal_type AND
689: ci.sequence_number = cir.sub_ci_sequence_number AND
690: ci.cal_type = ct.cal_type AND
691: ct.s_cal_cat = 'LOAD' AND