DBA Data[Home] [Help]

APPS.OKS_QA_DATA_INTEGRITY dependencies on RA_CUST_TRX_TYPES_ALL

Line 2795: FROM RA_CUST_TRX_TYPES_ALL

2791: IS
2792:
2793: CURSOR Cur_custtrx_type_id(bookId NUMBER, object1Id1 NUMBER, orgId NUMBER) IS
2794: SELECT Cust_trx_type_id
2795: FROM RA_CUST_TRX_TYPES_ALL
2796: WHERE SET_OF_BOOKS_ID = bookId
2797: AND org_id = orgId
2798: AND Cust_trx_type_id = NVL(object1Id1, - 99);
2799:

Line 2803: FROM RA_CUST_TRX_TYPES_ALL

2799:
2800:
2801: CURSOR Cur_default_custtrx_type_id(bookId NUMBER, orgId NUMBER) IS
2802: SELECT Cust_trx_type_id
2803: FROM RA_CUST_TRX_TYPES_ALL
2804: WHERE SET_OF_BOOKS_ID = bookId
2805: AND org_id = orgId
2806: AND TYPE = 'INV' AND name = 'Invoice-OKS' AND SYSDATE <= nvl(end_date, SYSDATE);
2807: