APPS.XLA_FSAH_DRILLDOWN_PKG SQL Statements

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

Line: 65

	  SELECT fnd_profile.VALUE('ICX_FORMS_LAUNCHER')
	  INTO l_protocol_port
	  FROM dual;

Line: 69

	  SELECT fnd_profile.VALUE('ICX_OA_HTML')
	  INTO l_virtual_path
	  FROM dual;

Line: 73

	  SELECT function_id
	  INTO l_function_id
	  FROM fnd_form_functions
	  WHERE function_name = 'XLA_LINESINQ_FSAH_DRILLDOWN';

Line: 79

	  select SUBSTR(FND_PROFILE.VALUE('ICX_FORMS_LAUNCHER'),1,INSTR(FND_PROFILE.VALUE('ICX_FORMS_LAUNCHER'),'/',1,3))
	  into l_protocol_port_value
	  from dual;

Line: 83

	  SELECT distinct
		rs.responsibility_id,
		rs.APPLICATION_ID,
		ur.SECURITY_GROUP_ID
	  INTO  l_resp_id,l_resp_appl_id,l_security_group_id
	  FROM fnd_responsibility rs,
	  FND_USER_RESP_GROUPS_ALL ur
	  WHERE rs.responsibility_id= ur.responsibility_id
	  and  responsibility_key='SLA_FSAH_LINESINQ_DRILLDOWN';