APPS.IGS_PR_GEN_004 dependencies on IGS_CA_STAT

Line 79: IGS_CA_STAT cs

75: cir.sup_ci_sequence_number
76: FROM IGS_CA_INST_REL cir,
77: IGS_CA_INST ci,
78: IGS_CA_TYPE ct,
79: IGS_CA_STAT cs
80: WHERE cir.sub_cal_type = p_cal_type AND
81: cir.sub_ci_sequence_number = p_ci_sequence_number AND
82: ci.cal_type = cir.sup_cal_type AND
83: ci.sequence_number = cir.sup_ci_sequence_number AND

Line 698: IGS_CA_STAT cs

694: cp_spo_cal_type IGS_CA_INST.cal_type%TYPE,
695: cp_spo_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
696: SELECT ci1.sequence_number
697: FROM IGS_CA_INST ci1,
698: IGS_CA_STAT cs
699: WHERE ci1.cal_type = cp_prg_cal_type AND
700: cs.CAL_STATUS = ci1.CAL_STATUS AND
701: cs.s_CAL_STATUS = cst_active AND
702: ci1.start_dt >

Line 2723: IGS_CA_STAT cs

2719: ci.cal_type,
2720: ci.sequence_number) acad_alternate_code
2721: FROM IGS_CA_INST ci,
2722: IGS_CA_TYPE cat,
2723: IGS_CA_STAT cs
2724: WHERE (p_prg_cal_type IS NULL OR
2725: (ci.cal_type = p_prg_cal_type AND
2726: ci.sequence_number = p_prg_sequence_number)) AND
2727: cat.cal_type = ci.cal_type AND

Line 3217: IGS_CA_STAT cs,

3213: -- attempt
3214: (SELECT MIN(ci2.start_dt)
3215: FROM IGS_CA_INST_REL cir,
3216: IGS_CA_INST ci2,
3217: IGS_CA_STAT cs,
3218: IGS_CA_TYPE cat
3219: WHERE cir.sub_cal_type = cp_cal_type AND
3220: cir.sub_ci_sequence_number = cp_ci_sequence_number AND
3221: ci2.cal_type = cir.sup_cal_type AND

Line 4842: IGS_CA_STAT cs

4838: cir.sub_ci_sequence_number
4839: FROM IGS_CA_INST ci,
4840: IGS_CA_INST_REL cir,
4841: IGS_CA_TYPE cat,
4842: IGS_CA_STAT cs
4843: WHERE cir.sup_cal_type = p_prg_cal_type AND
4844: cir.sup_ci_sequence_number = p_prg_sequence_number AND
4845: ci.cal_type = cir.sub_cal_type AND
4846: ci.sequence_number = cir.sub_ci_sequence_number AND

Line 4927: IGS_CA_STAT cs

4923: cir.sub_ci_sequence_number
4924: FROM IGS_CA_INST ci,
4925: IGS_CA_INST_REL cir,
4926: IGS_CA_TYPE cat,
4927: IGS_CA_STAT cs
4928: WHERE cir.sup_cal_type = p_prg_cal_type AND
4929: cir.sup_ci_sequence_number = p_prg_sequence_number AND
4930: ci.cal_type = cir.sub_cal_type AND
4931: ci.sequence_number = cir.sub_ci_sequence_number AND

Line 5037: IGS_CA_STAT cs

5033: cir.sub_ci_sequence_number
5034: FROM IGS_CA_INST ci,
5035: IGS_CA_INST_REL cir,
5036: IGS_CA_TYPE cat,
5037: IGS_CA_STAT cs
5038: WHERE cir.sup_cal_type = p_prg_cal_type AND
5039: cir.sup_ci_sequence_number = p_prg_sequence_number AND
5040: ci.cal_type = cir.sub_cal_type AND
5041: ci.sequence_number = cir.sub_ci_sequence_number AND