DBA Data[Home] [Help]

APPS.IGF_AP_OSS_INTR_DTLS dependencies on IGS_CA_INST_REL

Line 188: FROM igs_ca_inst_rel

184: IN
185: (
186: SELECT sup_cal_type,
187: sup_ci_sequence_number
188: FROM igs_ca_inst_rel
189: WHERE sub_cal_type = p_acad_cal_type
190: AND sub_ci_sequence_number = p_acad_seq_num
191: UNION
192: SELECT sub_cal_type,

Line 194: FROM igs_ca_inst_rel

190: AND sub_ci_sequence_number = p_acad_seq_num
191: UNION
192: SELECT sub_cal_type,
193: sub_ci_sequence_number
194: FROM igs_ca_inst_rel
195: WHERE sup_cal_type = p_acad_cal_type
196: AND sup_ci_sequence_number = p_acad_seq_num
197: )
198: AND

Line 319: FROM igs_ca_inst_rel,

315: CURSOR cur_fa_load_awd (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
316: IS
317: SELECT sub_cal_type,
318: sub_ci_sequence_number
319: FROM igs_ca_inst_rel,
320: igf_ap_fa_base_rec_all base
321: WHERE sup_cal_type = base.ci_cal_type
322: AND sup_ci_sequence_number = base.ci_sequence_number
323: AND base.base_id = p_base_id;