DBA Data[Home] [Help]

APPS.PER_PSO_SHD SQL Statements

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

Line: 69

    select
       organization_id
      ,security_profile_id
      ,entry_type
      ,object_version_number
      ,security_organization_id
    from        per_security_organizations
    where       security_organization_id = p_security_organization_id;
Line: 139

    select
       organization_id
      ,security_profile_id
      ,entry_type
      ,object_version_number
      ,security_organization_id
    from        per_security_organizations
    where       security_organization_id = p_security_organization_id
    for update nowait;