APPS.IEM_TAG_KEY_PVT dependencies on FND_LOOKUPS

Line 337: SELECT count(*) into l_id_count_rt from FND_LOOKUPS WHERE upper(lookup_code)=upper(l_key_id) and enabled_flag = 'Y' AND NVL(start_date_active, SYSDATE) <= SYSDATE AND NVL(end_date_active, SYSDATE) >= SYSDATE AND lookup_type = 'IEM_KEY_TYPE_CODE';

333: if l_id_count > 0 then
334: raise IEM_TAG_DUP_KEY_ID;
335: end if;
336:
337: SELECT count(*) into l_id_count_rt from FND_LOOKUPS WHERE upper(lookup_code)=upper(l_key_id) and enabled_flag = 'Y' AND NVL(start_date_active, SYSDATE) <= SYSDATE AND NVL(end_date_active, SYSDATE) >= SYSDATE AND lookup_type = 'IEM_KEY_TYPE_CODE';
338: if l_id_count_rt > 0 then
339: raise IEM_TAG_DUP_KEY_ID;
340: end if;
341:

Line 342: SELECT count(*) into l_id_count_cls from FND_LOOKUPS

338: if l_id_count_rt > 0 then
339: raise IEM_TAG_DUP_KEY_ID;
340: end if;
341:
342: SELECT count(*) into l_id_count_cls from FND_LOOKUPS
343: WHERE upper(lookup_code)=upper(l_key_id) and enabled_flag = 'Y'
344: AND NVL(start_date_active, SYSDATE) <= SYSDATE AND NVL(end_date_active, SYSDATE) >= SYSDATE AND lookup_type = 'IEM_CLASS_KEY_TYPE_CODE';
345: if l_id_count_cls > 0 then
346: raise IEM_TAG_DUP_KEY_ID;