APPS.INV_GLOBALS SQL Statements

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

Line: 21

    FND_API.g_entity_tbl.DELETE;

Line: 91

    ELSIF p_operation = G_OPR_UPDATE THEN

        l_control_rec.default_attributes:=   FALSE;

Line: 102

    ELSIF p_operation = G_OPR_DELETE THEN

        l_control_rec.default_attributes:=   FALSE;

Line: 341

          SELECT to_number(org_information1), to_number(org_information3)
            INTO X_ACCOUNT_INFO1, X_ACCOUNT_INFO3
          FROM   hr_organization_information
          WHERE  organization_id = P_Org_Id
            AND  org_information_context = P_ENTITY_CONTEXT;

Line: 357

          SELECT to_number(HOI.org_information1), to_number(HOI.org_information3), gsob.chart_of_accounts_id
            INTO X_ACCOUNT_INFO1, X_ACCOUNT_INFO3, X_COA_ID
          FROM   gl_sets_of_books gsob,
                 hr_organization_information HOI
          WHERE  HOI.organization_id = P_Org_Id
            AND  HOI.org_information_context = P_ENTITY_CONTEXT
            AND  gsob.set_of_books_id = DECODE(P_ENTITY_CONTEXT,
                                                  'Operating Unit Information',to_number(HOI.org_information3),
                                                  to_number(HOI.org_information1));