APPS.IGS_EN_GEN_015 dependencies on IGS_CA_INST_REL

Line 1260: igs_ca_inst_rel cir

1256: ci.end_dt
1257: FROM igs_ca_type ct,
1258: igs_ca_inst ci,
1259: igs_ca_stat cs,
1260: igs_ca_inst_rel cir
1261: WHERE ct.closed_ind = 'N'
1262: AND cs.s_cal_status = cst_active
1263: AND ci.cal_status = cs.cal_status
1264: AND ct.s_cal_cat = cst_load

Line 1270: AND EXISTS ( SELECT 1 FROM igs_ca_inst_rel cir,

1266: AND cir.sub_cal_type = ci.cal_type
1267: AND cir.sub_ci_sequence_number =ci.sequence_number
1268: AND cir.sup_cal_type = cp_cal_type
1269: AND cir.sup_ci_sequence_number = cp_sequence_number
1270: AND EXISTS ( SELECT 1 FROM igs_ca_inst_rel cir,
1271: igs_ca_type ct
1272: WHERE cir.sup_cal_type = cp_cal_type
1273: AND cir.sup_ci_sequence_number = cp_sequence_number
1274: AND cir.sub_cal_type = ci.cal_type

Line 2723: igs_ca_inst_rel cir

2719: ci.end_dt
2720: FROM igs_ca_type ct,
2721: igs_ca_inst ci,
2722: igs_ca_stat cs,
2723: igs_ca_inst_rel cir
2724: WHERE cs.s_cal_status = cst_active
2725: AND ci.cal_status = cs.cal_status
2726: AND ct.s_cal_cat = cst_load
2727: AND ci.cal_type = ct.cal_type

Line 2902: igs_ca_inst_rel cir

2898: ci.end_dt
2899: FROM igs_ca_type ct,
2900: igs_ca_inst ci,
2901: igs_ca_stat cs,
2902: igs_ca_inst_rel cir
2903: WHERE cs.s_cal_status = cst_active
2904: AND ci.cal_status = cs.cal_status
2905: AND ct.s_cal_cat = cst_load
2906: AND ci.cal_type = ct.cal_type

Line 2936: igs_ca_inst_rel cir

2932: ci.end_dt
2933: FROM igs_ca_type ct,
2934: igs_ca_inst ci,
2935: igs_ca_stat cs,
2936: igs_ca_inst_rel cir
2937: WHERE cs.s_cal_status = cst_active
2938: AND ci.cal_status = cs.cal_status
2939: AND ct.s_cal_cat = cst_load
2940: AND ci.cal_type = ct.cal_type

Line 3128: igs_ca_inst_rel cir

3124: ci.end_dt
3125: FROM igs_ca_type ct,
3126: igs_ca_inst ci,
3127: igs_ca_stat cs,
3128: igs_ca_inst_rel cir
3129: WHERE ct.closed_ind = 'N'
3130: AND cs.s_cal_status = cst_active
3131: AND ci.cal_status = cs.cal_status
3132: AND ct.s_cal_cat = cst_load

Line 3138: AND EXISTS ( SELECT 1 FROM igs_ca_inst_rel cir,

3134: AND cir.sub_cal_type = ci.cal_type
3135: AND cir.sub_ci_sequence_number =ci.sequence_number
3136: AND cir.sup_cal_type = cp_cal_type
3137: AND cir.sup_ci_sequence_number = cp_sequence_number
3138: AND EXISTS ( SELECT 1 FROM igs_ca_inst_rel cir,
3139: igs_ca_type ct
3140: WHERE cir.sup_cal_type = cp_cal_type
3141: AND cir.sup_ci_sequence_number = cp_sequence_number
3142: AND cir.sub_cal_type = ci.cal_type