[Home] [Help]
126: DECLARE
127: v_record_exists VARCHAR2(1);
128: CURSOR c_api IS
129: SELECT 'x'
130: FROM IGS_PE_ALT_PERS_ID api
131: WHERE pe_person_id = p_person_id AND
132: (api.start_dt IS NULL OR
133: api.start_dt <= p_effective_dt) AND
134: (api.end_dt IS NULL OR