DBA Data[Home] [Help]

APPS.PSP_PFT_SHD SQL Statements

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

Line: 47

    select
       period_frequency_id
      ,language
      ,period_frequency
      ,source_language
    from  psp_report_period_frequency_tl
    where period_frequency_id = p_period_frequency_id
    and   language = p_language;
Line: 113

    select
       period_frequency_id
      ,language
      ,period_frequency
      ,source_language
    from        psp_report_period_frequency_tl
    where       period_frequency_id = p_period_frequency_id
    and   language = p_language
    for update nowait;