DBA Data[Home] [Help]

APPS.PAY_BCT_SHD SQL Statements

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

Line: 66

    select
       batch_control_id
      ,batch_id
      ,control_status
      ,control_total
      ,control_type
      ,object_version_number
    from	pay_batch_control_totals
    where	batch_control_id = p_batch_control_id;
Line: 137

    select
       batch_control_id
      ,batch_id
      ,control_status
      ,control_total
      ,control_type
      ,object_version_number
    from	pay_batch_control_totals
    where	batch_control_id = p_batch_control_id
    for	update nowait;