DBA Data[Home] [Help]

APPS.OZF_SPECIAL_PRICING_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 1050: FROM ozf_funds_utilized_all_b u,

1046: CURSOR used_quantity_csr(p_offer_id NUMBER,
1047: p_product_id NUMBER) IS
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

Line 1069: FROM ozf_funds_utilized_all_b fu,

1065:
1066: CURSOR remaining_amount_csr( p_request_header_id NUMBER) is
1067: SELECT r.request_header_id,
1068: sum(fu.acctd_amount_remaining) amount_remaining
1069: FROM ozf_funds_utilized_all_b fu,
1070: ozf_request_headers_all_b r
1071: WHERE r.offer_id = fu.plan_id
1072: AND request_header_id = p_request_header_id
1073: GROUP BY r.request_header_id;