APPS.IGS_AD_GEN_006 dependencies on IGS_PE_VISA

Line 149: v_agent_person_id IGS_PE_VISA.agent_person_id%TYPE;

145: -- for use on letters.
146: DECLARE
147: cst_case_type CONSTANT VARCHAR2(6) := 'NORMAL';
148: cst_name_style CONSTANT VARCHAR2(5) := 'TITLE';
149: v_agent_person_id IGS_PE_VISA.agent_person_id%TYPE;
150: v_out_string VARCHAR2(2000);
151: CURSOR c_iv IS
152: SELECT agent_person_id
153: FROM IGS_PE_VISA iv

Line 153: FROM IGS_PE_VISA iv

149: v_agent_person_id IGS_PE_VISA.agent_person_id%TYPE;
150: v_out_string VARCHAR2(2000);
151: CURSOR c_iv IS
152: SELECT agent_person_id
153: FROM IGS_PE_VISA iv
154: WHERE person_id = p_person_id AND
155: agent_person_id IS NOT NULL AND
156: (visa_expiry_date > TRUNC(SYSDATE) OR
157: visa_expiry_date IS NULL);