DBA Data[Home] [Help]

APPS.HZ_UTILITY_V2PUB dependencies on HZ_CONTACT_POINTS

Line 2466: from hz_contact_points CPPH

2462: BEGIN
2463: select
2464: contact_point_id
2465: INTO l_contact_point_id
2466: from hz_contact_points CPPH
2467: where contact_point_type = 'PHONE'
2468: and primary_flag = 'Y'
2469: and status = 'A'
2470: and OWNER_TABLE_NAME = 'HZ_PARTIES'

Line 2504: from hz_contact_points

2500: BEGIN
2501:
2502: select email_address
2503: INTO l_primary_email
2504: from hz_contact_points
2505: where contact_point_type = 'EMAIL'
2506: and primary_flag = 'Y'
2507: and status = 'A'
2508: and OWNER_TABLE_NAME = 'HZ_PARTIES'