APPS.PV_MESSAGE SQL Statements

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

Line: 76

        cursor c1(NAME_ARG varchar2) is select message_text
            from fnd_new_messages m, fnd_application a
            where NAME_ARG = m.message_name
            and m.language_code = userenv('LANG')
            and APPIN = a.application_short_name
	    and m.application_id = a.application_id;

Line: 82

        cursor c2(NAME_ARG varchar2) is select message_text
            from fnd_new_messages m, fnd_application a
            where NAME_ARG = m.message_name
            and 'US' = m.language_code
            and APPIN = a.application_short_name
	    and m.application_id = a.application_id;

Line: 132

        cursor c1(NAME_ARG varchar2) is select message_number
            from fnd_new_messages m, fnd_application a
            where NAME_ARG = m.message_name
            and m.language_code = userenv('LANG')
            and APPIN = a.application_short_name
	    and m.application_id = a.application_id;

Line: 138

        cursor c2(NAME_ARG varchar2) is select message_number
            from fnd_new_messages m, fnd_application a
            where NAME_ARG = m.message_name
            and 'US' = m.language_code
            and APPIN = a.application_short_name
	    and m.application_id = a.application_id;