DBA Data[Home] [Help]

APPS.HZ_UTILITY_V2PUB dependencies on HZ_CONTACT_POINTS

Line 2450: from hz_contact_points CPPH

2446: BEGIN
2447: select
2448: contact_point_id
2449: INTO l_contact_point_id
2450: from hz_contact_points CPPH
2451: where contact_point_type = 'PHONE'
2452: and primary_flag = 'Y'
2453: and status = 'A'
2454: and OWNER_TABLE_NAME = 'HZ_PARTIES'

Line 2488: from hz_contact_points

2484: BEGIN
2485:
2486: select email_address
2487: INTO l_primary_email
2488: from hz_contact_points
2489: where contact_point_type = 'EMAIL'
2490: and primary_flag = 'Y'
2491: and status = 'A'
2492: and OWNER_TABLE_NAME = 'HZ_PARTIES'