APPS.PSP_PSC_SHD SQL Statements

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

Line: 53

    select
       salary_cap_id
      ,funding_source_code
      ,start_date
      ,end_date
      ,currency_code
      ,annual_salary_cap
      ,object_version_number
      ,seed_flag
    from        psp_salary_caps
    where       salary_cap_id = p_salary_cap_id;

Line: 126

    select
       salary_cap_id
      ,funding_source_code
      ,start_date
      ,end_date
      ,currency_code
      ,annual_salary_cap
      ,object_version_number
      ,seed_flag
    from        psp_salary_caps
    where       salary_cap_id = p_salary_cap_id
    for update nowait;