APPS.FA_UTILS_PKG SQL Statements

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

Line: 21

     /* look at the record and then the array and if no hit, then select */
     IF (h_set_of_books_id = faxcurr_record.set_of_books_id) then
        null;

Line: 41

           SELECT h_set_of_books_id,
                  curr.currency_code,
                  curr.precision
           INTO   faxcurr_record.set_of_books_id,
                  faxcurr_record.currency_code,
                  faxcurr_record.precision
           FROM   fnd_currencies curr, gl_sets_of_books sob
           WHERE  sob.set_of_books_id = h_set_of_books_id AND
                  curr.currency_code = sob.currency_code;

Line: 86

     /* look at the record and then the array and if no hit, then select */

     IF (h_set_of_books_id = faxcurr_record.set_of_books_id) then
        null;

Line: 108

           SELECT h_set_of_books_id,
                  curr.precision
           INTO   faxcurr_record.set_of_books_id,
                  faxcurr_record.precision
           FROM   fnd_currencies curr, gl_sets_of_books sob
           WHERE  sob.set_of_books_id = h_set_of_books_id AND
                  curr.currency_code = sob.currency_code;

Line: 153

     /* look at the record and then the array and if no hit, then select */
     IF (h_set_of_books_id = faxcurr_record.set_of_books_id) then
        null;

Line: 173

           SELECT h_set_of_books_id,
                  curr.currency_code,
                  curr.precision
           INTO   faxcurr_record.set_of_books_id,
                  faxcurr_record.currency_code,
                  faxcurr_record.precision
           FROM   fnd_currencies curr, gl_sets_of_books sob
           WHERE  sob.set_of_books_id = h_set_of_books_id AND
                  curr.currency_code = sob.currency_code;

Line: 217

     /* look at the record and then the array and if no hit, then select */
     IF (h_set_of_books_id = faxcurr_record.set_of_books_id) then
        null;

Line: 237

           SELECT h_set_of_books_id,
                  curr.currency_code,
                  curr.precision
           INTO   faxcurr_record.set_of_books_id,
                  faxcurr_record.currency_code,
                  faxcurr_record.precision
           FROM   fnd_currencies curr, gl_sets_of_books sob
           WHERE  sob.set_of_books_id = h_set_of_books_id AND
                  curr.currency_code = sob.currency_code;

Line: 288

	select 	T.MEANING
	into 	l_meaning
	from 	FA_LOOKUPS_TL T
	where   T.LANGUAGE = USERENV('LANG')
	and 	T.LOOKUP_TYPE = X_lookup_type
	and 	T.LOOKUP_CODE = X_lookup_code;

Line: 333

	SELECT  T.LOOKUP_CODE
	into 	l_lookup_code
	FROM 	FA_LOOKUPS_TL T
	WHERE   T.LANGUAGE = USERENV('LANG')
	AND 	T.LOOKUP_TYPE = X_lookup_type
	AND 	T.MEANING = X_meaning;