DBA Data[Home] [Help]

APPS.PSP_PSO_SHD SQL Statements

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

Line: 53

    select
       salary_cap_override_id
      ,funding_source_code
      ,project_id
      ,start_date
      ,end_date
      ,currency_code
      ,annual_salary_cap
      ,object_version_number
    from        psp_salary_cap_overrides
    where       salary_cap_override_id = p_salary_cap_override_id;
Line: 126

    select
       salary_cap_override_id
      ,funding_source_code
      ,project_id
      ,start_date
      ,end_date
      ,currency_code
      ,annual_salary_cap
      ,object_version_number
    from        psp_salary_cap_overrides
    where       salary_cap_override_id = p_salary_cap_override_id
    for update nowait;