APPS.HR_JP_STANDARD_PKG SQL Statements

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

Line: 617

			select	to_char(p_date, p_date_format, 'NLS_CALENDAR=''Japanese Imperial''')
			into	l_str
			from	dual;

Line: 621

			select	to_char(p_date, sys_context('USERENV', 'NLS_DATE_FORMAT'), 'NLS_CALENDAR=''Japanese Imperial''')
			into	l_str
			from	dual;

Line: 644

			select	to_date(p_str, p_date_format, 'NLS_CALENDAR=''Japanese Imperial''')
			into	l_date
			from	dual;

Line: 648

			select	to_date(p_str, sys_context('USERENV', 'NLS_DATE_FORMAT'), 'NLS_CALENDAR=''Japanese Imperial''')
			into	l_date
			from	dual;

Line: 905

		select	message_text
		from	fnd_application		a,
			fnd_new_messages	m
		where	a.application_short_name = p_application_short_name
		and	m.application_id = a.application_id
		and	m.message_name = p_message_name
		and	m.language_code = cp_language_code;