DBA Data[Home] [Help]

APPS.OKS_TAX_UTIL_PVT dependencies on RA_CUST_TRX_TYPES_ALL

Line 1142: FROM RA_CUST_TRX_TYPES_ALL

1138: IS
1139:
1140: CURSOR cur_custtrx_type_id(cp_book_id NUMBER, cp_object1id1 NUMBER, cp_org_id NUMBER) IS
1141: SELECT cust_trx_type_id
1142: FROM RA_CUST_TRX_TYPES_ALL
1143: WHERE SET_OF_BOOKS_ID = cp_book_id
1144: AND org_id = cp_org_id
1145: AND cust_trx_type_id = NVL(cp_object1id1, -99);
1146:

Line 1150: FROM RA_CUST_TRX_TYPES_ALL

1146:
1147:
1148: CURSOR cur_default_custtrx_type_id(cp_book_id NUMBER, cp_org_id NUMBER) IS
1149: SELECT cust_trx_type_id
1150: FROM RA_CUST_TRX_TYPES_ALL
1151: WHERE SET_OF_BOOKS_ID = cp_book_id
1152: AND org_id = cp_org_id
1153: AND TYPE = 'INV' AND name = 'Invoice-OKS' AND SYSDATE <= nvl(end_date, SYSDATE);
1154: