APPS.CSF_RESOURCE_PUB dependencies on HZ_PARTIES

Line 145: , hz_parties pa

141: FROM jtf_tasks_b tb
142: , cs_incidents_all_b ib
143: , cs_incidents_all_tl it
144: , hz_locations lo
145: , hz_parties pa
146: WHERE tb.task_id = p_task_id
147: AND tb.source_object_type_code = 'SR'
148: AND tb.source_object_id = ib.incident_id
149: AND tb.source_object_id = it.incident_id

Line 159: AND owner_table_name = 'HZ_PARTIES'

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';
162:
163: -- Service Item ID and Organization ID

Line 174: WHERE owner_table_name = 'HZ_PARTIES'

170: -- Contact VIP code
171: CURSOR c_class_code(b_party_id NUMBER) IS
172: SELECT class_code
173: FROM hz_code_assignments
174: WHERE owner_table_name = 'HZ_PARTIES'
175: AND owner_table_id = b_party_id;
176: BEGIN
177: OPEN c_rec;
178: