DBA Data[Home] [Help]

APPS.AST_ROUTING_PUB dependencies on HZ_CONTACT_POINTS

Line 116: from hz_contact_points

112: l_more_partyID NUMBER;
113:
114: cursor getPartyIDfromANI (p_ANI VARCHAR2) is
115: select owner_table_id
116: from hz_contact_points
117: where transposed_phone_number like p_ANI
118: and owner_table_name = 'HZ_PARTIES'
119: and status = 'A';
120: