APPS.ARP_LEGAL_ENTITY_UTIL SQL Statements

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

Line: 34

   Select Legal_entity_name
   INTO   l_legal_entity_name
   FROM  GL_LEDGER_LE_V
   WHERE legal_entity_id = p_legal_entity_id
     AND ledger_id = p_sob_id;

Line: 116

       SELECT NVL(legal_entity_id,-1)
       INTO   l_legal_entity_id
       FROM   RA_CUST_TRX_TYPES
       WHERE  cust_trx_type_id = p_trx_type_id;

Line: 141

       SELECT NVL(legal_entity_id,-1)
       INTO   l_legal_entity_id
       FROM   RA_BATCH_SOURCES
       WHERE  batch_source_id = p_batch_source_id;

Line: 254

     Select legal_entity_id
       BULK COLLECT INTO
          l_legal_entity_id
     from xle_le_ou_ledger_v
     where ledger_id = p_sob_id and
           operating_unit_id = p_org_id;

Line: 312

  Select legal_entity_name
   BULK COLLECT INTO
      l_legal_entity_name
   from xle_le_ou_ledger_v
  where ledger_id = p_sob_id and
        operating_unit_id = p_org_id;

Line: 350

     SELECT USE_LE_AS_SUBSCRIBER_FLAG
       INTO l_subscriber_flag
       FROM zx_party_tax_profile
      WHERE PARTY_TYPE_CODE = 'OU'
        AND PARTY_ID = arp_global.sysparam.org_id;

Line: 419

    select default_legal_context_id
    into   l_legal_entity_id
    from   hr_operating_units
    where  organization_id = p_org_id;