DBA Data[Home] [Help]

APPS.OKS_TAX_UTIL_PVT dependencies on RA_CUST_TRX_TYPES_ALL

Line 1190: FROM RA_CUST_TRX_TYPES_ALL

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:

Line 1198: FROM RA_CUST_TRX_TYPES_ALL

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: