APPS.PAY_KR_YEA_REPORTS_PKG SQL Statements

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

Line: 22

        select decode(p_report_name,'PAYKRYRS',hoi.org_information1
	                           ,'PAYKRYTR',hoi.org_information2
	                           ,'PAYKRYLG',hoi.org_information3)
	from   hr_all_organization_units hou,
	       hr_organization_information hoi
	where  hoi.organization_id = hou.organization_id
	  and  hou.business_group_id= p_bus_grp_id
          and  hoi.org_information_context = 'KR_YEA_REPORT_TEMPLATE_INFO';