APPS.PAY_PTA_SHD SQL Statements

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

Line: 56

    select
       dated_table_id
      ,table_name
      ,application_id
      ,surrogate_key_name
      ,start_date_name
      ,end_date_name
      ,business_group_id
      ,legislation_code
      ,object_version_number
      ,dyn_trigger_type
      ,dyn_trigger_package_name
      ,dyn_trig_pkg_generated
    from	pay_dated_tables
    where	dated_table_id = p_dated_table_id;

Line: 133

    select
       dated_table_id
      ,table_name
      ,application_id
      ,surrogate_key_name
      ,start_date_name
      ,end_date_name
      ,business_group_id
      ,legislation_code
      ,object_version_number
      ,dyn_trigger_type
      ,dyn_trigger_package_name
      ,dyn_trig_pkg_generated
    from	pay_dated_tables
    where	dated_table_id = p_dated_table_id
    for	update nowait;