APPS.GL_CONS_WRK_PKG SQL Statements

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

Line: 93

		SELECT DECODE (MAX (STATUS),
			'C', 'C',
			'U', 'U', 'N')
		INTO ret_val
		FROM GL_TRANSLATION_STATUSES
		WHERE ledger_id = X_ledger_id
		AND   period_name = X_period_name
		AND   target_currency = X_currency_code
		AND   actual_flag = X_actual_flag;