APPS.JL_BR_SPED_PUB dependencies on FND_LOOKUPS

Line 66: SELECT 'Yes' as isExist FROM FND_LOOKUPS

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

Line 270: SELECT 'Yes' as isExist FROM FND_LOOKUPS

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
271: WHERE LOOKUP_TYPE = 'JLBR_EI_STATUS'
272: AND LOOKUP_CODE = P_ELECT_INV_STATUS;
273:
274: l_api_name VARCHAR2(30) := 'INSERT_LOG';

Line 470: FROM FND_LOOKUPS

466: and geo_ident.geography_type = 'CITY';
467:
468: CURSOR get_bank_code IS
469: SELECT meaning
470: FROM FND_LOOKUPS
471: WHERE lookup_type = 'JLBR_CBANK_COUNTRY_CODES'
472: and lookup_code = (SELECT country
473: FROM hz_locations
474: WHERE location_id = P_LOCATION_ID);