DBA Data[Home] [Help]

APPS.OKL_STREAM_BILLING_PVT dependencies on OKX_CUST_TRX_TYPES_V

Line 325: FROM OKX_CUST_TRX_TYPES_V

321:
322: -- Replace with following query
323: CURSOR c_trx_id( p_sob_id NUMBER, p_org_id NUMBER ) IS
324: SELECT ID1
325: FROM OKX_CUST_TRX_TYPES_V
326: WHERE name = 'Invoice-OKL' AND
327: set_of_books_id = p_sob_id AND
328: org_id = p_org_id;
329:

Line 1200: FROM OKX_CUST_TRX_TYPES_V

1196: -- Get trx_id for Invoice
1197: ------------------------------------------------------------
1198: CURSOR c_trx_id( p_sob_id NUMBER, p_org_id NUMBER ) IS
1199: SELECT ID1
1200: FROM OKX_CUST_TRX_TYPES_V
1201: WHERE name = 'Invoice-OKL' AND
1202: set_of_books_id = p_sob_id AND
1203: org_id = p_org_id;
1204:

Line 1210: FROM OKX_CUST_TRX_TYPES_V

1206: -- Get trx_id for Credit Memo
1207: ------------------------------------------------------------
1208: CURSOR c_trx_id1( p_sob_id NUMBER, p_org_id NUMBER ) IS
1209: SELECT ID1
1210: FROM OKX_CUST_TRX_TYPES_V
1211: WHERE name = 'Credit Memo-OKL' AND
1212: set_of_books_id = p_sob_id AND
1213: org_id = p_org_id;
1214: