DBA Data[Home] [Help]

APPS.JE_IT_TAX_EX_UPGRADE2 SQL Statements

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

Line: 36

     SELECT default_legal_context_id
     INTO l_legal_entity_id
     FROM hr_operating_units
     WHERE organization_id = l_org_id;
Line: 54

       	UPDATE je_it_exlet_seqs
      	SET    legal_entity_id = l_legal_entity_id
      	WHERE  legal_entity_id IS NULL;
Line: 58

      	l_message := 'Updated '||SQL%ROWCOUNT||' records in je_it_exlet_seqs with legal entity id: '
                    ||l_legal_entity_id;
Line: 64

      	l_message := 'Unable to Update Legal Entities for the tables je_it_exlet_seqs
                         because no Legal Entity was found.';