DBA Data[Home] [Help]

APPS.JL_BR_SPED_PUB dependencies on RA_CUSTOMER_TRX_ALL

Line 61: SELECT 'Yes' as isExist FROM RA_CUSTOMER_TRX_ALL

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

Line 260: SELECT 'Yes' as isExist FROM RA_CUSTOMER_TRX_ALL

256: FROM JL_BR_CUSTOMER_TRX_EXTS
257: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
258:
259: CURSOR C_CUST_TRX_EXIST IS
260: SELECT 'Yes' as isExist FROM RA_CUSTOMER_TRX_ALL
261: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
262:
263: CURSOR C_VALID_EI_STATUS IS
264: SELECT 'Yes' as isExist FROM FND_LOOKUPS