DBA Data[Home] [Help]

APPS.JE_ES_MOD_LE_UPDATE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12

   SELECT DISTINCT org_id
   FROM je_es_modelo_190_all
   WHERE legal_entity_id IS NULL
   AND org_id IS NOT NULL;
Line: 35

                UPDATE je_es_modelo_190_all
                SET legal_entity_id = l_le_info
                WHERE org_id = l_org_id
                AND legal_entity_id IS NULL;