APPS.IGS_AD_GEN_012 dependencies on IGS_AD_OFR_RESP_STAT

Line 295: AND EXISTS (SELECT 'x' FROM igs_ad_ofr_resp_stat aors

291: FROM IGS_AD_PS_APPL_INST acai
292: WHERE EXISTS (SELECT 'x' from igs_ad_ou_stat aos
293: WHERE aos.adm_outcome_status = acai.adm_outcome_status
294: AND aos.s_adm_outcome_status IN ( cst_offer, cst_cond_offer))
295: AND EXISTS (SELECT 'x' FROM igs_ad_ofr_resp_stat aors
296: WHERE aors.adm_offer_resp_status = acai.adm_offer_resp_status
297: AND aors.s_adm_offer_resp_status = cst_pending
298: AND acai.offer_response_dt < TRUNC(SYSDATE))
299: FOR UPDATE OF acai.adm_offer_resp_status NOWAIT;