DBA Data[Home] [Help]

APPS.IGS_AD_IMP_OFF_RESP_DATA dependencies on IGS_CA_INST_REL

Line 274: igs_ca_inst_rel cir,

270: ,acad_ciav.s_cal_status s_cal_status
271: FROM
272: igs_ca_inst_alt_v acad_ciav,
273: igs_ca_inst_alt_v adm_ciav,
274: igs_ca_inst_rel cir,
275: igs_ad_prd_ad_prc_ca apapc,
276: igs_ca_type ct
277: WHERE
278: (acad_ciav.s_cal_cat = 'ACADEMIC' AND

Line 320: igs_ca_inst_rel cir

316: AND (ciav1.cal_type, ciav1.sequence_number) IN
317: (SELECT apapc.adm_cal_type,
318: apapc.adm_ci_sequence_number
319: FROM igs_ad_prd_ad_prc_ca apapc,
320: igs_ca_inst_rel cir
321: WHERE apapc.admission_cat = cp_admission_cat AND
322: apapc.s_admission_process_type =cp_s_adm_process_type AND
323: cir.sub_cal_type = apapc.adm_cal_type AND
324: cir.sub_ci_sequence_number = apapc.adm_ci_sequence_number AND