APPS.EDW_ORGANIZATION_PKG SQL Statements

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

Line: 23

select instance_code
from   edw_local_instance;

Line: 83

select 	'Y'
from 	hr_organization_information	oi
where	oi.org_information_context	= 'CLASS'
and	oi.org_information1		= 'OPERATING_UNIT'
and	oi.org_information2		= 'Y'
and 	oi.organization_id 		= p_id;

Line: 91

select instance_code
from   edw_local_instance;