APPS.JE_IT_TAX_EX_UPGRADE SQL Statements

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

Line: 25

    UPDATE je_it_year_ex_limit
    SET    legal_entity_id = p_legal_entity_id
    WHERE  set_of_books_id = p_set_of_books_id
    AND    legal_entity_id IS NULL;

Line: 30

    l_message := 'Updated '||SQL%ROWCOUNT||' rows in table je_it_year_ex_limit with
                  legal entity id: '||p_legal_entity_id||
                ' for set of books id: '||p_set_of_books_id;

Line: 35

    UPDATE je_it_exempt_letters
    SET    legal_entity_id = p_legal_entity_id
    WHERE  set_of_books_id = p_set_of_books_id
    AND    legal_entity_id IS NULL;

Line: 40

    l_message := 'Updated '||SQL%ROWCOUNT||' rows in table je_it_exempt_letters with
                  legal entity id: '||p_legal_entity_id||
                ' for set of books id: '||p_set_of_books_id;