APPS.CSF_RESOURCE_PUB dependencies on HZ_CONTACT_POINTS

Line 157: FROM hz_contact_points

153:
154: -- Phone Area Code
155: CURSOR c_contact_point(b_party_id NUMBER) IS
156: SELECT phone_area_code
157: FROM hz_contact_points
158: WHERE owner_table_id = b_party_id
159: AND owner_table_name = 'HZ_PARTIES'
160: AND contact_point_type = 'PHONE'
161: AND primary_flag = 'Y';