DBA Data[Home] [Help]

APPS.OZF_SPECIAL_PRICING_PVT dependencies on OZF_REQUEST_HEADERS_ALL_B

Line 1070: ozf_request_headers_all_b r

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;
1074: