APPS.IGF_AP_GEN_001 dependencies on IGS_CA_INST_REL

Line 307: FROM igs_ca_inst_rel

303: AND cty.cal_type = ci.cal_type
304: AND (ci.cal_type, ci.sequence_number)IN
305: (SELECT sup_cal_type,
306: sup_ci_sequence_number
307: FROM igs_ca_inst_rel
308: WHERE sub_cal_type = cp_aw_cal_type
309: AND sub_ci_sequence_number = cp_aw_seq_no
310: UNION
311: SELECT sub_cal_type,

Line 313: FROM igs_ca_inst_rel

309: AND sub_ci_sequence_number = cp_aw_seq_no
310: UNION
311: SELECT sub_cal_type,
312: sub_ci_sequence_number
313: FROM igs_ca_inst_rel
314: WHERE sup_cal_type = cp_aw_cal_type
315: AND sup_ci_sequence_number = cp_aw_seq_no
316: )
317: ORDER BY enrolled_end_dt DESC;

Line 334: FROM igs_ca_inst_rel

330: AND cty.cal_type = ci.cal_type
331: AND (ci.cal_type, ci.sequence_number)IN
332: (SELECT sup_cal_type,
333: sup_ci_sequence_number
334: FROM igs_ca_inst_rel
335: WHERE sub_cal_type = cp_aw_cal_type
336: AND sub_ci_sequence_number = cp_aw_seq_no
337: UNION
338: SELECT sub_cal_type,

Line 340: FROM igs_ca_inst_rel

336: AND sub_ci_sequence_number = cp_aw_seq_no
337: UNION
338: SELECT sub_cal_type,
339: sub_ci_sequence_number
340: FROM igs_ca_inst_rel
341: WHERE sup_cal_type = cp_aw_cal_type
342: AND sup_ci_sequence_number = cp_aw_seq_no
343: )
344: ORDER BY enrolled_start_dt;