DBA Data[Home] [Help]

APPS.IGF_AP_OSS_INTR_DTLS dependencies on IGS_AD_OU_STAT

Line 261: igs_ad_ou_stat prg_ou,

257: SELECT prg.attendance_type, prg.attendance_mode, prg.course_cd , prg.crv_version_number, prg.adm_outcome_status, prg.decision_date, prg.adm_offer_resp_status,
258: prg.actual_response_dt,prg.entry_level,prg.academic_index, prg.unit_set_cd, prg.us_version_number, prg_ou.s_adm_outcome_status ou_status,
259: prg_of.s_adm_offer_resp_status offer_status, prg.location_cd
260: FROM igs_ad_ps_appl_inst prg,
261: igs_ad_ou_stat prg_ou,
262: igs_ad_ofr_resp_stat prg_of
263: WHERE prg.rowid = lv_ad_prg_row_id
264: AND prg.adm_outcome_status = prg_ou.adm_outcome_status
265: AND prg.adm_offer_resp_status = prg_of.adm_offer_resp_status;