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
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