DBA Data[Home] [Help]

APPS.JTF_PLSQL_API SQL Statements

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

Line: 283

        SELECT  application_id
        FROM    fnd_application_vl
        WHERE   application_short_name = x_short_name;
Line: 288

        SELECT  msg.message_number
        FROM    fnd_new_messages msg, fnd_languages_vl lng
        WHERE   msg.message_name = x_msg
          and   msg.application_id = x_id
          and   lng.LANGUAGE_CODE = msg.language_code
          and   lng.language_id = x_lang_id;