APPS.IGS_EN_GEN_010 dependencies on IGS_CA_STAT

Line 1109: igs_ca_stat cs,

1105: SELECT ci.cal_type catalog_cal_type,
1106: ci.sequence_number catalog_seq_num
1107: FROM igs_ca_inst ci,
1108: igs_ca_type ct,
1109: igs_ca_stat cs,
1110: igs_ca_inst_rel cir
1111: WHERE ci.cal_type = ct.cal_type
1112: AND ct.s_cal_cat = 'LOAD'
1113: AND cs.cal_status = ci.cal_status

Line 2731: IGS_CA_STAT cs

2727: SELECT ci.sequence_number
2728: FROM IGS_CA_INST_REL cir,
2729: IGS_CA_INST ci,
2730: IGS_CA_TYPE cat,
2731: IGS_CA_STAT cs
2732: WHERE cir.sup_cal_type = p_acad_cal_type AND
2733: cir.sup_ci_sequence_number = p_acad_sequence_number AND
2734: ci.cal_type = cir.sub_cal_type AND
2735: ci.sequence_number = cir.sub_ci_sequence_number AND

Line 4378: IGS_CA_STAT cs

4374: SELECT ci.sequence_number
4375: FROM IGS_CA_INST_REL cir,
4376: IGS_CA_INST ci,
4377: IGS_CA_TYPE cat,
4378: IGS_CA_STAT cs
4379: WHERE cir.sup_cal_type = p_acad_cal_type AND
4380: cir.sup_ci_sequence_number = p_acad_sequence_number AND
4381: ci.cal_type = cir.sub_cal_type AND
4382: ci.sequence_number = cir.sub_ci_sequence_number AND

Line 6049: igs_ca_stat cs

6045: cir.sub_ci_sequence_number term_sequence_number
6046: FROM igs_ca_inst_rel cir,
6047: igs_ca_inst ci,
6048: igs_ca_type ct,
6049: igs_ca_stat cs
6050: WHERE cir.sup_cal_type = cp_acad_cal_type
6051: AND ct.cal_type = cir.sub_cal_type
6052: AND ct.s_cal_cat = 'LOAD'
6053: AND ci.cal_type = cir.sub_cal_type