APPS.OE_BULK_VALUE_TO_ID dependencies on FND_LOOKUPS

Line 480: FROM FND_LOOKUPS b, OE_HEADERS_IFACE_ALL d

476: (SELECT b.LOOKUP_CODE,
477: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
478: DECODE(b.LOOKUP_CODE,NULL,
479: c.ATTRIBUTE_STATUS||'006',c.ATTRIBUTE_STATUS)
480: FROM FND_LOOKUPS b, OE_HEADERS_IFACE_ALL d
481: WHERE d.TAX_EXEMPT_REASON = b.MEANING(+)
482: AND b.LOOKUP_TYPE(+) = 'ZX_EXEMPTION_REASON_CODE'
483: AND d.rowid = c.rowid)
484: WHERE c.batch_id = p_batch_id

Line 1282: FROM FND_LOOKUPS b, OE_LINES_IFACE_ALL d

1278: (SELECT b.LOOKUP_CODE,
1279: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1280: DECODE(b.LOOKUP_CODE,NULL,
1281: c.ATTRIBUTE_STATUS||'006',c.ATTRIBUTE_STATUS)
1282: FROM FND_LOOKUPS b, OE_LINES_IFACE_ALL d
1283: WHERE d.TAX_EXEMPT_REASON = b.MEANING(+)
1284: AND b.LOOKUP_TYPE(+) = 'ZX_EXEMPTION_REASON_CODE'
1285: AND b.enabled_flag(+) = 'Y'
1286: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)