APPS.PA_NL_INSTALLED SQL Statements

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

Line: 14

       SELECT DECODE(status,'I','Y','N')
       INTO   g_nl_installed
       FROM   fnd_product_installations
       WHERE  application_id = 8727 ;

Line: 61

    SELECT expenditure_item_id
    INTO   l_backout_id
    FROM   pa_expenditure_items_all
    WHERE  expenditure_id               = x_expenditure_id
    AND    adjusted_expenditure_item_id = x_exp_item_id;

Line: 80

    UPDATE pa_cost_distribution_lines_all
    SET    transfer_status_code = 'V'
    WHERE  expenditure_item_id  = l_backout_id;