APPS.CSF_RESOURCE_PUB dependencies on HZ_CONTACT_POINTS

Line 176: FROM hz_contact_points

172:
173: -- Phone Area Code
174: CURSOR c_contact_point(b_party_id NUMBER) IS
175: SELECT phone_area_code
176: FROM hz_contact_points
177: WHERE owner_table_id = b_party_id
178: AND owner_table_name = 'HZ_PARTIES'
179: AND contact_point_type = 'PHONE'
180: AND primary_flag = 'Y';