DBA Data[Home] [Help]

APPS.FUN_MULTI_SYSTEM_WF_PKG SQL Statements

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

Line: 18

|           return true. It will be updated when LE    |
|           API is available                           |
|-----------------------------------------------------*/


  FUNCTION IS_LOCAL (p_party_id IN NUMBER) return boolean
  IS

BEGIN

    -- always return true

    return TRUE;
Line: 83

                          SELECT   trx_id, recipient_id
                          FROM     FUN_TRX_HEADERS
                          WHERE    batch_id = p_batch_id;
Line: 155

        l_parameter_list.delete();
Line: 381

      SELECT  initiator_id, recipient_id
      INTO    l_initiator_id, l_recipient_id
      FROM    FUN_TRX_HEADERS
      WHERE   batch_id=l_batch_id
      AND     trx_id=l_trx_id;