APPS.PER_OSV_SHD SQL Statements

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

Line: 69

    select
       org_structure_version_id
      ,business_group_id
      ,organization_structure_id
      ,date_from
      ,version_number
      ,copy_structure_version_id
      ,date_to
      ,request_id
      ,program_application_id
      ,program_id
      ,program_update_date
      ,object_version_number
      ,topnode_pos_ctrl_enabled_flag
    from        per_org_structure_versions
    where       org_structure_version_id = p_org_structure_version_id;

Line: 147

    select
       org_structure_version_id
      ,business_group_id
      ,organization_structure_id
      ,date_from
      ,version_number
      ,copy_structure_version_id
      ,date_to
      ,request_id
      ,program_application_id
      ,program_id
      ,program_update_date
      ,object_version_number
      ,topnode_pos_ctrl_enabled_flag
    from        per_org_structure_versions
    where       org_structure_version_id = p_org_structure_version_id
    for update nowait;

Line: 228

  ,p_program_update_date            in date
  ,p_object_version_number          in number
  ,p_topnode_pos_ctrl_enabled_fla   in varchar2
  )
  Return g_rec_type is
--
  l_rec   g_rec_type;

Line: 250

  l_rec.program_update_date              := p_program_update_date;