1186: IS
1187:
1188: CURSOR cur_custtrx_type_id(cp_book_id NUMBER, cp_object1id1 NUMBER, cp_org_id NUMBER) IS
1189: SELECT cust_trx_type_id
1190: FROM RA_CUST_TRX_TYPES_ALL
1191: WHERE SET_OF_BOOKS_ID = cp_book_id
1192: AND org_id = cp_org_id
1193: AND cust_trx_type_id = NVL(cp_object1id1, -99);
1194:
1194:
1195:
1196: CURSOR cur_default_custtrx_type_id(cp_book_id NUMBER, cp_org_id NUMBER) IS
1197: SELECT cust_trx_type_id
1198: FROM RA_CUST_TRX_TYPES_ALL
1199: WHERE SET_OF_BOOKS_ID = cp_book_id
1200: AND org_id = cp_org_id
1201: AND TYPE = 'INV' AND name = 'Invoice-OKS' AND SYSDATE <= nvl(end_date, SYSDATE);
1202: