APPS.IES_TELESALES_BP_PKG SQL Statements

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

Line: 67

 	SELECT user_id
 	INTO   l_user_id
 	FROM   FND_USER
 	where user_name = p_user_name;

Line: 149

 SELECT user_id
 INTO   l_user_id
 FROM   FND_USER
 where user_name = p_user_name;

Line: 154

 SELECT resource_id
 INTO   l_resource_id
 FROM  jtf_rs_resource_extns
 WHERE user_name = p_user_name;

Line: 220

	SELECT user_id
	INTO   l_user_id
	FROM   FND_USER
	where user_name = p_user_name;

Line: 225

	SELECT jtf_amv_item_id
	INTO   l_content_id
	FROM AMS_DELIVERABLES_VL
	WHERE deliverable_id = p_deliverable_id;

Line: 313

	SELECT user_id
	INTO   l_user_id
	FROM   FND_USER
	where user_name = p_user_name;