DBA Data[Home] [Help]

APPS.PER_JGR_SHD SQL Statements

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

Line: 58

    select
       job_group_id
      ,business_group_id
      ,legislation_code
      ,internal_name
      ,displayed_name
      ,id_flex_num
      ,master_flag
      ,object_version_number
    from	per_job_groups
    where	job_group_id = p_job_group_id;
Line: 131

    select
       job_group_id
      ,business_group_id
      ,legislation_code
      ,internal_name
      ,displayed_name
      ,id_flex_num
      ,master_flag
      ,object_version_number
    from	per_job_groups
    where	job_group_id = p_job_group_id
    for	update nowait;