APPS.IGS_PR_GEN_003 dependencies on IGS_CA_STAT

Line 644: IGS_CA_STAT cs

640: SELECT cir.sub_cal_type cal_type, cir.sub_ci_sequence_number ci_sequence_number
641: FROM IGS_CA_INST ci ,
642: IGS_CA_INST_REL cir,
643: IGS_CA_TYPE cat,
644: IGS_CA_STAT cs
645: WHERE cir.sup_cal_type = cp_prg_cal_type
646: AND cir.sup_ci_sequence_number = cp_prg_sequence_number
647: AND ci.cal_type = cir.sub_cal_type
648: AND ci.sequence_number = cir.sub_ci_sequence_number