963: IF p_old_contact_tbl(loop_index).sr_contact_point_id is NULL
964: THEN
965: SELECT cs_hz_sr_contact_points_s.NEXTVAL
966: INTO l_sr_contact_point_id 967: FROM DUAL; 968: l_activity_code := 'C';
969: --
970: l_add_audit := 'Y';
971: INSERT INTO cs_hz_sr_contact_points