DBA Data[Home] [Help]

APPS.PSP_PFB_SHD SQL Statements

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

Line: 59

    select
       period_frequency_id
      ,object_version_number
      ,start_date
      ,unit_of_measure
      ,period_duration
      ,report_type
    from        psp_report_period_frequency_b
    where       period_frequency_id = p_period_frequency_id;
Line: 130

    select
       period_frequency_id
      ,object_version_number
      ,start_date
      ,unit_of_measure
      ,period_duration
      ,report_type
    from        psp_report_period_frequency_b
    where       period_frequency_id = p_period_frequency_id
    for update nowait;