APPS.IGS_AD_GEN_006 dependencies on IGS_AD_PS_APPL_INST

Line 193: v_out_date IGS_AD_PS_APPL_INST.offer_response_dt%TYPE;

189: p_acai_sequence_number IN NUMBER )
190: RETURN VARCHAR2 IS
191: BEGIN
192: DECLARE
193: v_out_date IGS_AD_PS_APPL_INST.offer_response_dt%TYPE;
194: CURSOR c_acai IS
195: SELECT acai.offer_response_dt
196: FROM IGS_AD_PS_APPL_INST acai
197: WHERE acai.person_id = p_person_id AND

Line 196: FROM IGS_AD_PS_APPL_INST acai

192: DECLARE
193: v_out_date IGS_AD_PS_APPL_INST.offer_response_dt%TYPE;
194: CURSOR c_acai IS
195: SELECT acai.offer_response_dt
196: FROM IGS_AD_PS_APPL_INST acai
197: WHERE acai.person_id = p_person_id AND
198: acai.admission_appl_number = p_admission_appl_number AND
199: acai.nominated_course_cd = p_nominated_course_cd AND
200: acai.sequence_number = p_acai_sequence_number;