APPS.AHL_UTIL_MC_PKG SQL Statements

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

Line: 23

	SELECT 	'x'
	FROM 	FND_LOOKUPS
	WHERE 	lookup_type = p_lookup_type AND
		lookup_code = p_lookup_code AND
		G_TRUNC_DATE between TRUNC(NVL(start_date_active, SYSDATE)) AND TRUNC(NVL(end_date_active, SYSDATE+1)) AND
                --JKJain, Bug 12593041 29th July 2011.
                NVL(enabled_flag, 'Y') = 'Y';

Line: 66

	SELECT 	lookup_code
	FROM 	fnd_lookups
	WHERE 	lookup_type = p_lookup_type AND
		upper(meaning) = upper(p_lookup_meaning) AND
		G_TRUNC_DATE between TRUNC(NVL(start_date_active, SYSDATE)) AND TRUNC(NVL(end_date_active, SYSDATE+1));

Line: 123

	SELECT 	meaning
	FROM 	fnd_lookups
	WHERE 	lookup_type = p_lookup_type AND
		lookup_code = p_lookup_code AND
		G_TRUNC_DATE between TRUNC(NVL(start_date_active, SYSDATE)) AND TRUNC(NVL(end_date_active, SYSDATE+1));

Line: 162

	SELECT 	'x'
	FROM 	ahl_item_groups_b
	WHERE 	item_group_id = p_item_group_id;

Line: 202

	SELECT 	position_ref_code
	FROM   	ahl_mc_relationships
	WHERE 	relationship_id = p_relationship_id AND
		-- Since positions with active_start_date > sysdate are also displayed in the MC tree, no need to check for active_start_date
		-- G_TRUNC_DATE between TRUNC(NVL(active_start_date, SYSDATE)) AND TRUNC(NVL(active_end_date, SYSDATE+1));

Line: 243

	SELECT 	'x'
	FROM   	ahl_mc_relationships
	WHERE 	relationship_id = p_relationship_id AND
		-- Since positions with active_start_date > sysdate are also displayed in the MC tree, no need to check for active_start_date
		-- G_TRUNC_DATE between TRUNC(NVL(active_end_date, SYSDATE)) AND TRUNC(NVL(active_end_date, SYSDATE+1));