APPS.AP_WEB_AMOUNT_UTIL SQL Statements

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

Line: 21

     select fu.user_id
      into l_user_id
      from fnd_user fu
      where fu.employee_id = p_employee_id
      and sysdate >= fu.start_date
      and sysdate <= nvl(fu.end_date, sysdate)
      and rownum = 1;

Line: 56

    select round(p_amount, fc.precision)
    into l_value
    from fnd_currencies_vl fc
    where currency_code = p_curr_code;

Line: 89

      select menu_id, responsibility_id
      into l_menu_id, l_responsibility_id
      from (
         select fr.menu_id, fr.responsibility_id
         from fnd_responsibility fr,
         fnd_user_resp_groups furg
         where fr.application_id = 200
         and fr.version = 'W'
         and furg.user_id = p_user_id
         and furg.responsibility_id = fr.responsibility_id
         order by furg.start_date desc
      )
      where rownum=1;

Line: 169

      select base_currency_code, asp.set_of_books_id, asp.default_exchange_rate_type
      into   l_curr_code, l_sob_id, l_default_exchange_rate_type
      from  ap_system_parameters_all asp
      where asp.org_id = p_org_id;

Line: 301

	    select asp.default_exchange_rate_type
	    into  l_exchange_rate_type
	    from per_employees_x pex,
		 ap_system_parameters_all asp,
		 fnd_user fu
	    where
		pex.set_of_books_id = asp.set_of_books_id  and
		fu.employee_id = pex.employee_id and
		fu.user_id = p_userid and
		rownum = 1;