DBA Data[Home] [Help]

APPS.OZF_FUND_UTILIZED_PUB dependencies on OE_ORDER_LINES_ALL

Line 206: FROM oe_order_lines_all

202:
203: --Order_Line_Id validation added for ER-6858324
204: CURSOR c_order_line (p_order_line_id IN NUMBER, p_header_id IN NUMBER) IS
205: SELECT 1
206: FROM oe_order_lines_all
207: WHERE line_id = p_order_line_id
208: AND header_id = p_header_id;
209:
210: CURSOR c_org_id (p_org_id IN NUMBER, p_fund_id IN NUMBER) IS

Line 231: FROM oe_order_headers_all h, oe_order_lines_all l

227:
228: --nirprasa,ER 8399134
229: CURSOR c_org_order_line (p_order_line_id IN NUMBER) IS
230: SELECT h.org_id
231: FROM oe_order_headers_all h, oe_order_lines_all l
232: WHERE h.header_id = l.header_id
233: AND l.line_id = p_order_line_id ;
234:
235: CURSOR c_offer_info (p_activity_id IN NUMBER) IS

Line 289: FROM oe_order_lines_all ol, oe_order_headers_all oh

285: WHERE po_header_id = p_document_number;
286:
287: CURSOR c_get_header_id(p_order_line_id IN NUMBER) IS
288: SELECT oh.transactional_curr_code
289: FROM oe_order_lines_all ol, oe_order_headers_all oh
290: WHERE ol.line_id = p_order_line_id
291: AND ol.header_id = oh.header_id;
292:
293: CURSOR c_get_camp_currency (p_activity_id IN NUMBER) IS