DBA Data[Home] [Help]

APPS.PAY_APM_SHD SQL Statements

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

Line: 73

    select
       process_module_id
      ,process_id
      ,module_id
      ,process_sequence
      ,enabled_flag
      ,object_version_number
    from        pay_au_process_modules
    where       process_module_id = p_process_module_id;
Line: 144

    select
       process_module_id
      ,process_id
      ,module_id
      ,process_sequence
      ,enabled_flag
      ,object_version_number
    from        pay_au_process_modules
    where       process_module_id = p_process_module_id
    for update nowait;