APPS.AP_WEB_INFRASTRUCTURE_PKG SQL Statements

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

Line: 45

   SELECT        LANGUAGE_CODE
   INTO          l_languageCode
   FROM          FND_LANGUAGES
   WHERE         INSTALLED_FLAG = 'B';

Line: 201

    SELECT distinct(nvl(fl.org_id,fd.org_id))
    INTO   l_org_id
    FROM   ap_expense_feed_lines_all fl,
	   ap_expense_feed_dists_all fd
    WHERE  fl.employee_verification_id = p_id
    OR     (fd.feed_line_id = fl.feed_line_id AND
	   fd.employee_verification_id = p_id);

Line: 213

    SELECT distinct(org_id)
    INTO   l_org_id
    FROM   ap_expense_feed_dists_all
    WHERE  manager_approval_id = p_id;

Line: 289

			 p_update in boolean default TRUE) return boolean is

begin

  return icx_sec.validatesession(p_func, '', p_commit, p_update);