APPS.JTF_TASK_MASS_PVT SQL Statements

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

Line: 75

		select resource_type
        -- Bug Fix 2909730, Bug# 4455786 MOAC.
		from jtf_task_resources_vl
		where resource_id = b_task_resource_id;

Line: 140

					l_sql_stmt := 'SELECT resource_id FROM jtf_rs_group_members WHERE group_id = :id and delete_flag = ''N''';

Line: 142

			   		l_sql_stmt := 'SELECT resource_id FROM jtf_rs_group_members WHERE group_id = :id and resource_id != :keep_resource_id and delete_flag = ''N''';

Line: 153

			    l_sql_stmt := 'SELECT team_resource_id FROM jtf_rs_team_members WHERE team_id = :id and resource_type = ''INDIVIDUAL'' and delete_flag = ''N''';

Line: 155

			     l_sql_stmt := 'SELECT team_resource_id FROM jtf_rs_team_members WHERE team_id = :id and resource_type = ''INDIVIDUAL'' and team_resource_id != :keep_resource_id and delete_flag = ''N''';

Line: 161

			-- If p_keep_record is 'Y' then select all the members for a given group or a team
			--
			OPEN mass_task FOR l_sql_stmt USING p_resource_id;

Line: 166

			-- If p_keep_record is 'N' then select all the members for a given group or a team except the task owner
			--
			OPEN mass_task FOR l_sql_stmt USING p_resource_id, p_keep_resource_id;

Line: 309

		-- Declare a cursor to select the resource_id
		--
		cursor c_resource is
		select resource_id
        -- Bug Fix 2909730, Bug# 4455786 MOAC.
		from jtf_task_resources_vl
		where resource_id = p_resource_type_id
		and resource_type = p_resource_type;