APPS.PAY_KR_NPA_FUNC_PKG SQL Statements

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

Line: 13

		select distinct
			hou.name bp_name
		from
			hr_organization_units hou,
			hr_organization_information npi
		where
			hou.business_group_id		= p_business_group_id
			and npi.organization_id 	= hou.organization_id
			and npi.org_information_context = 'KR_NP_INFORMATION'
			and npi.org_information1	= p_bp_np_number
		order by
			1 ;