DBA Data[Home] [Help]

APPS.OKL_STREAM_BILLING_PVT dependencies on OKX_CUST_TRX_TYPES_V

Line 323: FROM OKX_CUST_TRX_TYPES_V

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

Line 1138: FROM OKX_CUST_TRX_TYPES_V

1134: -- Get trx_id for Invoice
1135: ------------------------------------------------------------
1136: CURSOR c_trx_id( p_sob_id NUMBER, p_org_id NUMBER ) IS
1137: SELECT ID1
1138: FROM OKX_CUST_TRX_TYPES_V
1139: WHERE name = 'Invoice-OKL' AND
1140: set_of_books_id = p_sob_id AND
1141: org_id = p_org_id;
1142:

Line 1148: FROM OKX_CUST_TRX_TYPES_V

1144: -- Get trx_id for Credit Memo
1145: ------------------------------------------------------------
1146: CURSOR c_trx_id1( p_sob_id NUMBER, p_org_id NUMBER ) IS
1147: SELECT ID1
1148: FROM OKX_CUST_TRX_TYPES_V
1149: WHERE name = 'Credit Memo-OKL' AND
1150: set_of_books_id = p_sob_id AND
1151: org_id = p_org_id;
1152: