APPS.OZF_FUND_UTILIZED_PUB dependencies on PO_HEADERS_ALL

Line 247: SELECT org_id FROM po_headers_all

243: WHERE resale_line_id = p_line_id;
244:
245: -- Cursor to get the org_id for purchase order
246: CURSOR c_purchase_order_org_id (p_header_id IN NUMBER) IS
247: SELECT org_id FROM po_headers_all
248: WHERE po_header_id = p_header_id;
249:
250: -- Cursor to get the org_id for invoice
251: CURSOR c_invoice_org_id (p_cust_trx_id IN NUMBER)IS

Line 284: SELECT currency_code FROM po_headers_all

280: FROM ra_customer_trx_all
281: WHERE customer_trx_id = p_document_number;
282:
283: CURSOR c_get_pcho_currency (p_document_number IN NUMBER) IS
284: SELECT currency_code FROM po_headers_all
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