DBA Data[Home] [Help]

APPS.PQP_ERG_SHD SQL Statements

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

Line: 84

    select
       exception_group_id
      ,exception_group_name
      ,exception_report_id
      ,legislation_code
      ,business_group_id
      ,consolidation_set_id
      ,payroll_id
      ,object_version_number
      ,output_format
    from        pqp_exception_report_groups
    where       exception_group_id = p_exception_group_id;
Line: 158

    select
       exception_group_id
      ,exception_group_name
      ,exception_report_id
      ,legislation_code
      ,business_group_id
      ,consolidation_set_id
      ,payroll_id
      ,object_version_number
      ,output_format
    from        pqp_exception_report_groups
    where       exception_group_id = p_exception_group_id
    for update nowait;