30:
31: -- Replace with following query
32: CURSOR c_trx_id( p_sob_id NUMBER, p_org_id NUMBER ) IS
33: SELECT ID1
34: FROM OKX_CUST_TRX_TYPES_V
35: WHERE name = 'Invoice-OKL' AND
36: set_of_books_id = p_sob_id AND
37: org_id = p_org_id;
38:
243: -- Get trx_id for Invoice
244: ------------------------------------------------------------
245: CURSOR c_trx_id( p_sob_id NUMBER, p_org_id NUMBER ) IS
246: SELECT ID1
247: FROM OKX_CUST_TRX_TYPES_V
248: WHERE name = 'Invoice-OKL' AND
249: set_of_books_id = p_sob_id AND
250: org_id = p_org_id;
251:
255: -- Get trx_id for Credit Memo
256: ------------------------------------------------------------
257: CURSOR c_trx_id1( p_sob_id NUMBER, p_org_id NUMBER ) IS
258: SELECT ID1
259: FROM OKX_CUST_TRX_TYPES_V
260: WHERE name = 'Credit Memo-OKL' AND
261: set_of_books_id = p_sob_id AND
262: org_id = p_org_id; */
263:
1800: -- Get trx_id for Invoice
1801: ------------------------------------------------------------
1802: CURSOR c_trx_id( p_sob_id NUMBER, p_org_id NUMBER ) IS
1803: SELECT ID1
1804: FROM OKX_CUST_TRX_TYPES_V
1805: WHERE name = 'Invoice-OKL' AND
1806: set_of_books_id = p_sob_id AND
1807: org_id = p_org_id;
1808:
1812: -- Get trx_id for Credit Memo
1813: ------------------------------------------------------------
1814: CURSOR c_trx_id1( p_sob_id NUMBER, p_org_id NUMBER ) IS
1815: SELECT ID1
1816: FROM OKX_CUST_TRX_TYPES_V
1817: WHERE name = 'Credit Memo-OKL' AND
1818: set_of_books_id = p_sob_id AND
1819: org_id = p_org_id; */
1820: