APPS.OZF_TP_UTIL_QUERIES dependencies on AMS_ACT_ACCESS_DENORM

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

Line 381: from ams_act_access_denorm act

377: and qp.source_system_code = FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE')
378: and NVL(off.budget_offer_yn,'N') = 'N';
379: ELSIF p_object_class = 'CSCH' THEN
380: select count(act.object_id) into x_object_count
381: from ams_act_access_denorm act
382: where act.object_id = p_object_id
383: and act.object_type = p_object_class
384: and act.resource_id= p_resource_id;
385: END IF;