APPS.OZF_FUND_UTILIZED_PUB dependencies on OZF_RESALE_LINES_ALL

Line 242: SELECT org_id FROM ozf_resale_lines_all

238: WHERE qp_list_header_id = p_activity_id;
239:
240: -- Cursor to get the org_id for third party order
241: CURSOR c_tp_order_org_id (p_line_id IN NUMBER) IS
242: SELECT org_id FROM ozf_resale_lines_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

Line 275: FROM ozf_resale_lines_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
275: FROM ozf_resale_lines_all
276: WHERE resale_line_id = p_document_number;
277:
278: CURSOR c_get_txn_currency (p_document_number IN NUMBER) IS
279: SELECT invoice_currency_code