APPS.OZF_SPECIAL_PRICING_PVT dependencies on AMS_ACT_PRODUCTS

Line 1052: ams_act_products a

1048: SELECT sum(l.scan_unit) * a.quantity quantity_remaining,
1049: a.uom_code
1050: FROM ozf_funds_utilized_all_b u,
1051: ozf_claim_lines_util_all l,
1052: ams_act_products a
1053: WHERE u.utilization_id = l.utilization_id
1054: AND u.activity_product_id = a.activity_product_id
1055: AND u.plan_type = 'OFFR'
1056: AND u.plan_id = p_offer_id