APPS.IGS_PR_GEN_001 dependencies on IGS_CA_INST_REL

Line 276: IGS_CA_INST_REL cir,

272: SELECT cir.sub_cal_type,
273: cir.sub_ci_sequence_number
274: FROM IGS_CA_TYPE cat,
275: IGS_CA_INST ci,
276: IGS_CA_INST_REL cir,
277: IGS_CA_STAT cs
278: WHERE cir.sup_cal_type = p_prg_cal_type AND
279: cir.sup_ci_sequence_number = p_prg_sequence_number AND
280: ci.cal_type = cir.sub_cal_type AND

Line 291: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,

287: -- kdande; 22-Apr-2003; Bug# 2829262
288: -- Added uoo_id field to the SELECT clause of cursor c_sua_sca.
289: --
290: CURSOR c_sua_sca (
291: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
292: cp_sub_ci_sequence_number IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
293: SELECT sua.unit_cd,
294: sua.cal_type,
295: sua.ci_sequence_number,

Line 292: cp_sub_ci_sequence_number IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS

288: -- Added uoo_id field to the SELECT clause of cursor c_sua_sca.
289: --
290: CURSOR c_sua_sca (
291: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
292: cp_sub_ci_sequence_number IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
293: SELECT sua.unit_cd,
294: sua.cal_type,
295: sua.ci_sequence_number,
296: sua.unit_attempt_status,

Line 320: IGS_CA_INST_REL cir,

316: SELECT cir.sup_cal_type,
317: cir.sup_ci_sequence_number
318: FROM IGS_CA_TYPE cat,
319: IGS_CA_INST ci1,
320: IGS_CA_INST_REL cir,
321: IGS_CA_STAT cs
322: WHERE cir.sub_cal_type = cp_sua_cal_type AND
323: cir.sub_ci_sequence_number = cp_sua_ci_sequence_number AND
324: ci1.cal_type = cir.sup_cal_type AND

Line 447: IGS_CA_INST_REL cir,

443: SELECT cir.sub_cal_type,
444: cir.sub_ci_sequence_number
445: FROM IGS_CA_TYPE cat,
446: IGS_CA_INST ci,
447: IGS_CA_INST_REL cir,
448: IGS_CA_STAT cs
449: WHERE cir.sup_cal_type = p_prg_cal_type AND
450: cir.sup_ci_sequence_number = p_prg_sequence_number AND
451: ci.cal_type = cir.sub_cal_type AND

Line 462: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,

458: -- kdande; 22-Apr-2003; Bug# 2829262
459: -- Added uoo_id field to the SELECT clause of the cursor c_sua_sca.
460: --
461: CURSOR c_sua_sca (
462: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
463: cp_sub_ci_sequence_number
464: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
465: SELECT sua.unit_cd,
466: sua.cal_type,

Line 464: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS

460: --
461: CURSOR c_sua_sca (
462: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
463: cp_sub_ci_sequence_number
464: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
465: SELECT sua.unit_cd,
466: sua.cal_type,
467: sua.ci_sequence_number,
468: sua.unit_attempt_status,