DBA Data[Home] [Help]

APPS.IGS_PR_GEN_001 dependencies on IGS_CA_STAT

Line 277: IGS_CA_STAT cs

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
281: ci.sequence_number = cir.sub_ci_sequence_number AND

Line 321: IGS_CA_STAT cs

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
325: ci1.sequence_number = cir.sup_ci_sequence_number AND

Line 448: IGS_CA_STAT cs

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
452: ci.sequence_number = cir.sub_ci_sequence_number AND