APPS.OZF_SPECIAL_PRICING_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 1126: FROM ozf_funds_utilized_all_b u,

1122: CURSOR used_quantity_csr(p_offer_id NUMBER,
1123: p_product_id NUMBER) IS
1124: SELECT sum(l.scan_unit) * a.quantity quantity_remaining,
1125: a.uom_code
1126: FROM ozf_funds_utilized_all_b u,
1127: ozf_claim_lines_util_all l,
1128: ams_act_products a
1129: WHERE u.utilization_id = l.utilization_id
1130: AND u.activity_product_id = a.activity_product_id

Line 1145: FROM ozf_funds_utilized_all_b fu,

1141:
1142: CURSOR remaining_amount_csr( p_request_header_id NUMBER) is
1143: SELECT r.request_header_id,
1144: sum(fu.acctd_amount_remaining) amount_remaining
1145: FROM ozf_funds_utilized_all_b fu,
1146: ozf_request_headers_all_b r
1147: WHERE r.offer_id = fu.plan_id
1148: AND request_header_id = p_request_header_id
1149: GROUP BY r.request_header_id;