APPS.IGC_LEDGER_UTILS SQL Statements

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

Line: 26

    SELECT cc_bc_enable_flag
          ,cbc_po_enable
    FROM igc_cc_bc_enable
    WHERE set_of_books_id = p_ledger_id;

Line: 91

    SELECT  primary_ledger_id
    FROM    GL_LEDGER_RELATIONSHIPS
    WHERE   target_ledger_category_code = 'SECONDARY'
    AND     relationship_type_code <> 'NONE'
    AND     application_id = 101
    AND     target_ledger_id = p_ledger_id;

Line: 120

  SELECT SEC.LEDGER_ID,
         SEC.LEDGER_NAME
  FROM   GL_SECONDARY_LEDGER_RSHIPS_V SEC
         , GL_LEDGERS LED
  WHERE  LED.LEDGER_ID = SEC.LEDGER_ID
  AND    LED.COMMITMENT_BUDGET_FLAG = 'Y'
  AND    SEC.PRIMARY_LEDGER_ID = p_primary_ledger_id;