DBA Data[Home] [Help]

APPS.IEX_CASE_CONTACTS_PVT dependencies on HZ_CONTACT_POINTS

Line 53: from hz_contact_points

49: AND IDENTIFYING_ADDRESS_FLAG = 'Y';
50:
51: cursor c_get_phone(x_owner_table_id number) is
52: select contact_point_id
53: from hz_contact_points
54: where owner_table_id = x_owner_table_id
55: and owner_table_name = 'HZ_PARTIES'
56: and contact_point_type = 'PHONE'
57: and primary_flag = 'Y';