APPS.CSF_TASKS_PUB dependencies on HZ_CONTACT_POINTS

Line 92: from hz_contact_points

88: select decode(phone_country_code,'','',phone_country_code || '-' ) ||
89: decode(phone_area_code,'','',phone_area_code || '-' ) || phone_number
90: into l_phone
91: from (select phone_number, phone_area_code, phone_country_code
92: from hz_contact_points
93: where owner_table_id = party_id
94: and owner_table_name ='HZ_PARTY_SITES'
95: and contact_point_type = 'PHONE'
96: order by primary_flag desc, creation_date asc)

Line 4907: FROM hz_contact_points cp

4903: || DECODE(cp.phone_area_code, '', '', NULL, '', cp.phone_area_code || '-')
4904: || cp.phone_number phone
4905: , cp.phone_extension
4906: , cp.email_address
4907: FROM hz_contact_points cp
4908: , ar_lookups ar
4909: WHERE cp.contact_point_id = l_contact_point_id
4910: AND cp.contact_point_type IN ('EMAIL', 'PHONE')
4911: AND cp.phone_line_type = ar.lookup_code (+)