DBA Data[Home] [Help]

APPS.OZF_FUND_UTILIZED_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 158: FROM oe_order_headers_all a

154:
155: --Order_Line_Id validation added for ER-6858324
156: CURSOR c_order_line (p_order_line_id IN NUMBER) IS
157: SELECT 1
158: FROM oe_order_headers_all a
159: , oe_order_lines_all b
160: WHERE b.line_id = p_order_line_id
161: AND a.header_id = b.header_id;
162:

Line 541: FROM oe_order_headers_all

537: AND liability_flag= 'Y';
538:
539: CURSOR c_org_order (p_doc_number IN NUMBER) IS
540: SELECT org_id
541: FROM oe_order_headers_all
542: WHERE header_id = p_doc_number;
543:
544: CURSOR c_org_fund (p_fund_id IN NUMBER) IS
545: SELECT org_id