APPS.GL_GLXRLBOL_XMLP_PKG SQL Statements

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

Line: 48

    SELECT name
    INTO   DAS_NAME
    FROM   gl_access_sets
    WHERE  access_set_id = P_DAS_ID;

Line: 70

  select enable_budgetary_control_flag
  into control_flag
  from gl_ledgers led
  where led.ledger_id = P_LEDGER_ID;

Line: 84

    SELECT be.name, be.description, lk.meaning, be.start_date, be.end_date
    INTO   ORGNAME, ORGDESC, ORGPASS, STARTDATE, ENDDATE
    FROM   GL_BUDGET_ENTITIES be, GL_LOOKUPS lk
    --WHERE  be.budget_entity_id = P_BUDGET_ENTITY_ID
    WHERE  be.budget_entity_id = P_BUDGET_ENTITY_ID_NEW
    AND    lk.lookup_code = be.budget_password_required_flag
    AND    lk.lookup_type = 'YES/NO';

Line: 124

  select be.budget_entity_id
  into   all_bud_ent_id
  from   gl_lookups l, gl_budget_entities be
  where  l.lookup_type = 'LITERAL'
  and    l.lookup_code = 'ALL'
  and    upper(be.name) = upper(l.meaning)
  and    be.ledger_id = p_ledger_id;