APPS.GL_LEDGER_UTILS_PKG SQL Statements

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

Line: 15

      SELECT ledger_id, decode(object_type_code, 'S', NULL, currency_code), 'N'
      FROM   GL_LEDGERS
      WHERE  short_name = X_Ledger_Short_Name;

Line: 20

      SELECT target_ledger_id, target_currency_code,
             decode(relationship_type_code, 'BALANCE', 'Y', 'N')
      FROM   GL_LEDGER_RELATIONSHIPS
      WHERE  target_ledger_short_name = X_Ledger_Short_Name;

Line: 47

      SELECT short_name, 'N'
      FROM   GL_LEDGERS
      WHERE  ledger_id = X_Ledger_Id
      AND    (   object_type_code = 'S'
              OR decode(X_Ledger_Currency, Null, 'Y', currency_code) =
                                           nvl(X_Ledger_Currency, 'Y') );

Line: 55

      SELECT target_ledger_short_name,
             decode(relationship_type_code, 'BALANCE', 'Y', 'N')
      FROM   GL_LEDGER_RELATIONSHIPS
      WHERE  target_ledger_id = X_Ledger_Id
      AND    target_currency_code = X_Ledger_Currency
      AND    application_id = 101;

Line: 96

      SELECT target_currency_code
      FROM   GL_LEDGER_RELATIONSHIPS
      WHERE  target_ledger_short_name = X_Ledger_Short_Name;

Line: 101

      SELECT currency_code
      FROM   GL_LEDGERS
      WHERE  ledger_id = (select default_ledger_id
                          from   GL_ACCESS_SETS
                          where  access_set_id =
                                 (select implicit_access_set_id
                                  from   GL_LEDGERS
                                  where  short_name = X_Ledger_Short_Name));

Line: 136

      SELECT TARGET_LEDGER_ID
      FROM GL_LEDGER_SET_ASSIGNMENTS ASG,
           GL_LEDGER_RELATIONSHIPS LR
      WHERE ASG.LEDGER_SET_ID = P_LEDGER_SET_ID
      AND LR.TARGET_LEDGER_ID = ASG.LEDGER_ID
      AND LR.SOURCE_LEDGER_ID = ASG.LEDGER_ID
      AND LR.TARGET_CURRENCY_CODE = P_LEDGER_CURRENCY;