APPS.PAY_RFT_SHD SQL Statements

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

Line: 47

    select
       report_format_mapping_id
      ,language
      ,source_lang
      ,display_name
    from  pay_report_format_mappings_tl
    where report_format_mapping_id = p_report_format_mapping_id
    and   language = p_language;

Line: 113

    select
       report_format_mapping_id
      ,language
      ,source_lang
      ,display_name
    from        pay_report_format_mappings_tl
    where       report_format_mapping_id = p_report_format_mapping_id
    and   language = p_language
    for update nowait;

Line: 174

  delete from PAY_REPORT_FORMAT_MAPPINGS_TL T
   where not exists
      ( select NULL
          from PAY_REPORT_FORMAT_MAPPINGS_F B
         where B.REPORT_FORMAT_MAPPING_ID = T.REPORT_FORMAT_MAPPING_ID );

Line: 180

  update PAY_REPORT_FORMAT_MAPPINGS_TL T
     set ( DISPLAY_NAME ) =
              ( select B.DISPLAY_NAME
                  from PAY_REPORT_FORMAT_MAPPINGS_TL B
                 where B.REPORT_FORMAT_MAPPING_ID = T.REPORT_FORMAT_MAPPING_ID
                 and B.LANGUAGE = T.SOURCE_LANG )
     where (
             T.REPORT_FORMAT_MAPPING_ID,
             T.LANGUAGE
           ) in
           ( select
                SUBT.REPORT_FORMAT_MAPPING_ID,
                SUBT.LANGUAGE
                from PAY_REPORT_FORMAT_MAPPINGS_TL SUBB,
                     PAY_REPORT_FORMAT_MAPPINGS_TL SUBT
               where SUBB.REPORT_FORMAT_MAPPING_ID = SUBT.REPORT_FORMAT_MAPPING_ID
                 and SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME )
           );

Line: 200

  insert into PAY_REPORT_FORMAT_MAPPINGS_TL
      (
        REPORT_FORMAT_MAPPING_ID,
        DISPLAY_NAME,
        LANGUAGE,
        SOURCE_LANG
      )
      select /*+ ORDERED */
           B.REPORT_FORMAT_MAPPING_ID,
           B.DISPLAY_NAME,
           L.LANGUAGE_CODE,
           B.SOURCE_LANG
      from PAY_REPORT_FORMAT_MAPPINGS_TL B,
           FND_LANGUAGES L
     where L.INSTALLED_FLAG in ('I', 'B')
       and B.LANGUAGE = userenv('LANG')
       and not exists
           ( select NULL
               from PAY_REPORT_FORMAT_MAPPINGS_TL T
              where T.REPORT_FORMAT_MAPPING_ID = B.REPORT_FORMAT_MAPPING_ID
                and T.LANGUAGE = L.LANGUAGE_CODE );