APPS.FA_ROUND_PKG SQL Statements

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

Line: 13

    select curr.precision
    into h_precision
    from fnd_currencies curr, gl_sets_of_books sob,
	 fa_book_controls bc
    where curr.currency_code = sob.currency_code
    and  sob.set_of_books_id = bc.set_of_books_id
    and bc.book_type_code = X_book;

Line: 21

    select round(X_amount,h_precision)
    into X_amount
    from dual;

Line: 36

    select curr.precision
    into h_precision
    from fnd_currencies curr, gl_sets_of_books sob,
	 fa_book_controls bc
    where curr.currency_code = sob.currency_code
    and  sob.set_of_books_id = bc.set_of_books_id
    and bc.book_type_code = X_book;

Line: 44

    select  ceil(X_amount * power(10,h_precision)) / power(10,h_precision)
    into X_amount
    from dual;

Line: 60

    select curr.precision
    into h_precision
    from fnd_currencies curr, gl_sets_of_books sob,
	 fa_book_controls bc
    where curr.currency_code = sob.currency_code
    and  sob.set_of_books_id = bc.set_of_books_id
    and bc.book_type_code = X_book;

Line: 68

    select  trunc(X_amount * power(10,h_precision)) / power(10,h_precision)
    into X_amount
    from dual;