APPS.PAY_KR_HIA_FUNC_PKG SQL Statements

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

Line: 16

	select  hou1.name
	from 	hr_organization_units       hou1,
		hr_organization_information hoi2,
		pay_payroll_actions         ppa
	where   ppa.payroll_action_id        = p_payroll_action_id
	and     hou1.business_group_id       = ppa.business_group_id
	and     hou1.organization_id         = hoi2.organization_id
	and     hoi2.org_information_context = 'KR_HI_INFORMATION'
	and     hoi2.org_information1        = p_hi_bp_number;