DBA Data[Home] [Help]

APPS.GL_GLOBAL SQL Statements

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

Line: 31

           SELECT set_of_books_id INTO current_ledger_id
           FROM   HR_OPERATING_UNITS
           WHERE  organization_id = Context_Id;
Line: 37

           SELECT prilgr.ledger_id
           INTO   current_ledger_id
           FROM   GL_LEDGER_CONFIG_DETAILS cfgDet,
                  GL_LEDGER_CONFIGURATIONS cfg,
                  GL_LEDGERS Prilgr
           WHERE  cfgDet.object_id = Context_Id
           AND    cfgDet.object_type_code  = 'LEGAL_ENTITY'
           AND    cfgDet.configuration_id  = cfg.configuration_id
           AND    cfg.configuration_id = prilgr.configuration_id
           AND    prilgr.ledger_category_code = 'PRIMARY';