APPS.HXC_RDB_RECIPIENT_SNAPSHOT SQL Statements

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

Line: 10

         IS SELECT pa.expenditure_item_id,
                   exp.expenditure_group,
                   ROWIDTOCHAR(ret.rowid)
              FROM hxc_ret_pa_latest_details ret,
                   pa_expenditure_items_all pa,
                   pa_expenditures_all exp
             WHERE ret.request_id = p_request_id
               AND pa.transaction_source = 'ORACLE TIME AND LABOR'
               AND pa.orig_transaction_reference = ret.time_building_block_id||':'||ret.object_version_number
               AND pa.net_zero_adjustment_flag = 'Y'
    			     AND pa.expenditure_id = exp.expenditure_id
               AND ret.old_measure IS NOT NULL;

Line: 24

         IS SELECT pa.expenditure_item_id,
                   exp.expenditure_group,
                   ROWIDTOCHAR(ret.rowid)
              FROM hxc_ret_pa_latest_details ret,
                   pa_expenditure_items_all pa,
                   pa_expenditures_all exp
             WHERE ret.request_id = p_request_id
               AND pa.transaction_source = 'ORACLE TIME AND LABOR'
               AND pa.orig_transaction_reference = ret.time_building_block_id||':'||ret.object_version_number
               AND pa.net_zero_adjustment_flag = 'N'
    			     AND pa.expenditure_id = exp.expenditure_id ;

Line: 89

           UPDATE hxc_ret_pa_latest_details
              SET retro_pei_id = eitab(i),
                  retro_exp_group = ettab(i)
            WHERE ROWID = CHARTOROWID(rowtab(i));

Line: 107

           UPDATE hxc_ret_pa_latest_details
              SET pei_id = eitab(i),
                  exp_group = ettab(i)
            WHERE ROWID = CHARTOROWID(rowtab(i));

Line: 148

      DELETE FROM hxc_rdb_pending_processes
            WHERE request_id = l_request_id;