DBA Data[Home] [Help]

APPS.ENI_PARAM_UTIL_PKG SQL Statements

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

Line: 9

	SELECT
		id,
		value
	FROM
		eni_oltp_item_star
        WHERE rownum = 1;
Line: 43

	select id into l_first_item from eni_oltp_item_star
	where organization_id = to_number(eni_param_util_pkg.g_default_org) and rownum = 1;
Line: 46

	select id into l_first_item from eni_oltp_item_star
	where rownum = 1;
Line: 65

SELECT
	'Y'
FROM
/*Bug: 4960454*/
	fnd_user_resp_groups_all
WHERE
	responsibility_id = resp_id
	AND as_of_date BETWEEN start_date AND NVL(end_date, SYSDATE)
	AND user_id = FND_GLOBAL.USER_ID;
Line: 78

SELECT
	'Y'
FROM
	mtl_parameters
WHERE
	organization_id = org_id;
Line: 133

   SELECT organization_id into l_first_item_org	FROM	eni_oltp_item_star
       WHERE rownum = 1;