DBA Data[Home] [Help]

APPS.IGS_PR_GEN_003 dependencies on IGS_CA_INST_REL

Line 642: IGS_CA_INST_REL cir,

638: CURSOR c_cir (cp_prg_cal_type igs_ca_inst.cal_type%TYPE,
639: cp_prg_sequence_number igs_ca_inst.sequence_number%TYPE) IS
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