APPS.OZF_FUND_UTILIZED_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 219: FROM oe_order_headers_all

215: AND hr.set_of_books_id = fund.ledger_id;
216:
217: CURSOR c_org_order (p_header_id IN NUMBER) IS
218: SELECT org_id
219: FROM oe_order_headers_all
220: WHERE header_id = p_header_id;
221:
222: CURSOR c_inventory_org (p_org_id IN NUMBER) IS
223: SELECT parameter_value

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 270: FROM oe_order_headers_all

266: WHERE qp_list_header_id=p_activity_id;
267:
268: CURSOR c_get_order_currency (p_document_number IN NUMBER) IS
269: SELECT transactional_curr_code
270: FROM oe_order_headers_all
271: WHERE header_id = p_document_number;
272:
273: CURSOR c_get_tp_order_currency (p_document_number IN NUMBER) IS
274: SELECT currency_code

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

Line 1145: FROM oe_order_headers_all

1141:
1142: /* 07-APR-09 kdass bug 8402334
1143: CURSOR c_org_order (p_doc_number IN NUMBER) IS
1144: SELECT org_id
1145: FROM oe_order_headers_all
1146: WHERE header_id = p_doc_number;
1147:
1148: CURSOR c_org_fund (p_fund_id IN NUMBER) IS
1149: SELECT org_id