DBA Data[Home] [Help]

APPS.JTF_TASK_UTL dependencies on JTF_PARTY_CONT_POINTS_V

Line 359: FROM jtf_party_cont_points_v

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;

Line 368: FROM jtf_party_cont_points_v

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