DBA Data[Home] [Help]

APPS.JL_BR_SPED_PUB dependencies on RA_CUSTOMER_TRX_ALL

Line 62: SELECT 'Yes' as isExist FROM RA_CUSTOMER_TRX_ALL

58: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID
59: AND ELECTRONIC_INV_STATUS IN ('2','7');
60:
61: CURSOR C_CUST_TRX_EXIST IS
62: SELECT 'Yes' as isExist FROM RA_CUSTOMER_TRX_ALL
63: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
64:
65: CURSOR C_VALID_EI_STATUS IS
66: SELECT 'Yes' as isExist FROM FND_LOOKUPS

Line 266: SELECT 'Yes' as isExist FROM RA_CUSTOMER_TRX_ALL

262: FROM JL_BR_CUSTOMER_TRX_EXTS
263: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
264:
265: CURSOR C_CUST_TRX_EXIST IS
266: SELECT 'Yes' as isExist FROM RA_CUSTOMER_TRX_ALL
267: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
268:
269: CURSOR C_VALID_EI_STATUS IS
270: SELECT 'Yes' as isExist FROM FND_LOOKUPS