APPS.JL_BR_SPED_PUB dependencies on FND_LOOKUPS

Line 65: SELECT 'Yes' as isExist FROM FND_LOOKUPS

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
66: WHERE LOOKUP_TYPE = 'JLBR_EI_STATUS'
67: AND LOOKUP_CODE = P_ELECT_INV_STATUS;
68:
69: l_count NUMBER;

Line 264: SELECT 'Yes' as isExist FROM FND_LOOKUPS

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
265: WHERE LOOKUP_TYPE = 'JLBR_EI_STATUS'
266: AND LOOKUP_CODE = P_ELECT_INV_STATUS;
267:
268: l_api_name VARCHAR2(30) := 'INSERT_LOG';

Line 464: FROM FND_LOOKUPS

460: and geo_ident.geography_type = 'CITY';
461:
462: CURSOR get_bank_code IS
463: SELECT meaning
464: FROM FND_LOOKUPS
465: WHERE lookup_type = 'JLBR_CBANK_COUNTRY_CODES'
466: and lookup_code = (SELECT country
467: FROM hz_locations
468: WHERE location_id = P_LOCATION_ID);