DBA Data[Home] [Help]

APPS.OKS_QA_DATA_INTEGRITY dependencies on RA_CUST_TRX_TYPES_ALL

Line 2726: FROM RA_CUST_TRX_TYPES_ALL

2722: IS
2723:
2724: CURSOR Cur_custtrx_type_id(bookId NUMBER, object1Id1 NUMBER, orgId NUMBER) IS
2725: SELECT Cust_trx_type_id
2726: FROM RA_CUST_TRX_TYPES_ALL
2727: WHERE SET_OF_BOOKS_ID = bookId
2728: AND org_id = orgId
2729: AND Cust_trx_type_id = NVL(object1Id1, - 99);
2730:

Line 2734: FROM RA_CUST_TRX_TYPES_ALL

2730:
2731:
2732: CURSOR Cur_default_custtrx_type_id(bookId NUMBER, orgId NUMBER) IS
2733: SELECT Cust_trx_type_id
2734: FROM RA_CUST_TRX_TYPES_ALL
2735: WHERE SET_OF_BOOKS_ID = bookId
2736: AND org_id = orgId
2737: AND TYPE = 'INV' AND name = 'Invoice-OKS' AND SYSDATE <= nvl(end_date, SYSDATE);
2738: