DBA Data[Home] [Help]

APPS.JTF_TASK_PHONES_PUB dependencies on HZ_CONTACT_POINTS

Line 793: FROM hz_contact_points

789: SET primary_flag = 'N'
790: WHERE task_contact_id = p_task_contact_id
791: AND phone_id IN
792: ( SELECT contact_point_id
793: FROM hz_contact_points
794: WHERE contact_point_type =
795: (SELECT contact_point_type
796: FROM hz_contact_points
797: WHERE contact_point_id = p_phone_id

Line 796: FROM hz_contact_points

792: ( SELECT contact_point_id
793: FROM hz_contact_points
794: WHERE contact_point_type =
795: (SELECT contact_point_type
796: FROM hz_contact_points
797: WHERE contact_point_id = p_phone_id
798: AND owner_table_id =
799: (SELECT contact_id
800: FROM jtf_task_contacts

Line 815: FROM hz_contact_points

811: SET primary_flag = 'N'
812: WHERE task_contact_id = p_task_contact_id
813: AND phone_id IN
814: ( SELECT contact_point_id
815: FROM hz_contact_points
816: WHERE contact_point_type =
817: (SELECT contact_point_type
818: FROM hz_contact_points
819: WHERE contact_point_id =

Line 818: FROM hz_contact_points

814: ( SELECT contact_point_id
815: FROM hz_contact_points
816: WHERE contact_point_type =
817: (SELECT contact_point_type
818: FROM hz_contact_points
819: WHERE contact_point_id =
820: p_phone_id
821: AND owner_table_id =
822: (SELECT customer_id

Line 851: FROM hz_contact_points

847: FROM jtf_task_phones
848: WHERE task_phone_id = p_task_phone_id)
849: AND phone_id IN
850: ( SELECT contact_point_id
851: FROM hz_contact_points
852: WHERE contact_point_type =
853: (SELECT contact_point_type
854: FROM hz_contact_points
855: WHERE contact_point_id = p_phone_id

Line 854: FROM hz_contact_points

850: ( SELECT contact_point_id
851: FROM hz_contact_points
852: WHERE contact_point_type =
853: (SELECT contact_point_type
854: FROM hz_contact_points
855: WHERE contact_point_id = p_phone_id
856: AND owner_table_id = l_contact_id
857: )
858: AND owner_table_id = l_contact_id