APPS.FUN_IC_AME_WF_PKG SQL Statements

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

Line: 33

       SELECT DISTINCT hz.party_name
       INTO   l_return_value
       FROM   hz_parties hz,
              fun_trx_batches btch,
              fun_trx_headers head
       WHERE  hz.party_id         = btch.initiator_id
       AND    btch.batch_id       = head.batch_id
       AND    head.trx_id         = p_transaction_id;

Line: 44

       SELECT DISTINCT xla.name
       INTO   l_return_value
       FROM   xle_firstparty_information_v xla,
              fun_trx_batches btch,
              fun_trx_headers head
       WHERE  xla.legal_entity_id = btch.from_le_id
       AND    btch.batch_id       = head.batch_id
       AND    head.trx_id         = p_transaction_id;

Line: 55

       SELECT DISTINCT gl.name
       INTO   l_return_value
       FROM   gl_ledgers gl,
              fun_trx_batches btch,
              fun_trx_headers head
       WHERE  gl.ledger_id        = btch.from_ledger_id
       AND    btch.batch_id       = head.batch_id
       AND    head.trx_id         = p_transaction_id;

Line: 66

       SELECT DISTINCT tt.trx_type_name
       INTO   l_return_value
       FROM   fun_trx_types_tl tt,
              fun_trx_batches btch,
              fun_trx_headers head
       WHERE  tt.trx_type_id      = btch.trx_type_id
       AND    btch.batch_id       = head.batch_id
       AND    head.trx_id         = p_transaction_id;

Line: 77

       SELECT DISTINCT hz.party_name
       INTO   l_return_value
       FROM   hz_parties hz,
              fun_trx_headers head
       WHERE  hz.party_id         = head.initiator_id
       AND    head.trx_id         = p_transaction_id;

Line: 86

       SELECT DISTINCT hz.party_name
       INTO   l_return_value
       FROM   hz_parties hz,
              fun_trx_headers head
       WHERE  hz.party_id         = head.recipient_id
       AND    head.trx_id         = p_transaction_id;

Line: 95

       SELECT DISTINCT xla.name
       INTO   l_return_value
       FROM   xle_firstparty_information_v xla,
              fun_trx_headers head
       WHERE  xla.legal_entity_id = head.to_le_id
       AND    head.trx_id         = p_transaction_id;

Line: 104

       SELECT DISTINCT gl.name
       INTO   l_return_value
       FROM   gl_ledgers gl,
              fun_trx_headers head
       WHERE  gl.ledger_id        = head.to_ledger_id
       AND    head.trx_id         = p_transaction_id;

Line: 113

       SELECT DISTINCT hz.party_name
       INTO   l_return_value
       FROM   hz_parties hz,
              fun_dist_lines dist
       WHERE  hz.party_id         = dist.party_id
       AND    dist.dist_id        = p_dist_id;

Line: 187

   SELECT chart_of_accounts_id
   INTO  l_chart_of_accounts_id
   FROM  gl_ledgers gl,
         fun_trx_headers head
   WHERE gl.ledger_id = head.to_ledger_id
   AND   head.trx_id  = p_transaction_id;