APPS.IGS_PR_GEN_003 dependencies on IGS_CA_INST

Line 638: CURSOR c_cir (cp_prg_cal_type igs_ca_inst.cal_type%TYPE,

634: ORDER BY scpm.calculation_dt DESC;
635:
636: --
637: -- Start of new code added to fix Bug# 3103892; nalkumar; 22-Aug-2003
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,

Line 639: cp_prg_sequence_number igs_ca_inst.sequence_number%TYPE) IS

635:
636: --
637: -- Start of new code added to fix Bug# 3103892; nalkumar; 22-Aug-2003
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,

Line 641: FROM IGS_CA_INST ci ,

637: -- Start of new code added to fix Bug# 3103892; nalkumar; 22-Aug-2003
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

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