DBA Data[Home] [Help]

APPS.PAY_APP_SHD SQL Statements

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

Line: 72

    select
       process_parameter_id
      ,process_id
      ,internal_name
      ,data_type
      ,enabled_flag
      ,object_version_number
    from        pay_au_process_parameters
    where       process_parameter_id = p_process_parameter_id;
Line: 143

    select
       process_parameter_id
      ,process_id
      ,internal_name
      ,data_type
      ,enabled_flag
      ,object_version_number
    from        pay_au_process_parameters
    where       process_parameter_id = p_process_parameter_id
    for update nowait;