APPS.IGS_EN_GEN_003 dependencies on IGS_AD_OFR_RESP_STAT

Line 785: IGS_AD_OFR_RESP_STAT ar

781: CURSOR c_apai(cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
782: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE) IS
783: SELECT count(ai.person_id) cnt
784: FROM IGS_AD_PS_APPL_INST ai,
785: IGS_AD_OFR_RESP_STAT ar
786: WHERE ai.adm_offer_resp_status = ar.adm_offer_resp_status AND
787: ar.s_adm_offer_resp_status = 'ACCEPTED' AND
788: ai.person_id = cp_person_id AND
789: ai.course_cd = cp_course_cd ;