[Home] [Help]
355: end if;
356:
357: SELECT 1
358: INTO x
359: FROM jtf_party_cont_points_v
360: WHERE party_id in (l_rel_party_id ,l_person_party_id)
361: AND contact_point_id = p_phone_id
362: AND status = 'A'
363: AND ROWNUM < 2;
364: ELSE
365:
366: SELECT 1
367: INTO x
368: FROM jtf_party_cont_points_v
369: WHERE party_id = (SELECT customer_id
370: FROM jtf_tasks_b
371: WHERE task_id = p_contact_id)
372: AND contact_point_id = p_phone_id