APPS.OZF_TP_UTIL_QUERIES dependencies on OZF_OFFERS

Line 371: from ams_act_access_denorm act, qp_list_headers_b qp, ozf_offers off

367: BEGIN
368:
369: IF p_object_class = 'OFFR' THEN
370: select count(act.object_id) into x_object_count
371: from ams_act_access_denorm act, qp_list_headers_b qp, ozf_offers off
372: where act.object_id = p_object_id
373: and act.object_type = p_object_class
374: and act.resource_id= p_resource_id
375: and qp.list_header_id = act.object_id