APPS.HR_DK_UTILITY SQL Statements

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

Line: 71

      SELECT SUBSTR(TRIM(
             TRIM(p_last_name)
	   || ', '
           ||TRIM(p_first_name)
           ||' '
	   ||TRIM(p_middle_name)
	   ||' '
	   ||TRIM(p_per_information1))
           , 1, 240)
       INTO   l_full_name
       FROM   dual;

Line: 154

      SELECT SUBSTR(TRIM(p_last_name)||','||TRIM(p_first_name) ||
		    DECODE(TRIM(P_MIDDLE_NAME),NULL,'', ',' || TRIM(p_middle_name)), 1, 240)
      INTO   l_order_name
      FROM   dual;

Line: 360

		select SOFT_CODING_KEYFLEX_ID
		from  PER_ALL_ASSIGNMENTS_F
		where assignment_id = p_assignment_id;

Line: 365

		select ORGANIZATION_ID
		from  PER_ALL_ASSIGNMENTS_F
		where assignment_id = p_assignment_id;

Line: 370

		select lookups.meaning
		from HR_SOFT_CODING_KEYFLEX scl, hr_lookups lookups
		where scl.SOFT_CODING_KEYFLEX_ID = l_scl_id
		and lookups.lookup_type=l_information_code
		and lookups.enabled_flag = 'Y'
		and lookups.lookup_code = decode(l_information_code,'DK_COND_OF_EMP',scl.segment3,
													   'DK_EMP_GROUP',scl.segment4,NULL);

Line: 379

		select lookups.meaning
		from hr_organization_units hou, hr_organization_information hoi , hr_lookups lookups
		where hou.organization_id = l_organization_id
		and hou.organization_id = hoi.organization_id
		and hoi.org_information_context = 'DK_EMPLOYMENT_DEFAULTS'
		and lookups.lookup_type = l_information_code
		and lookups.enabled_flag = 'Y'
		and lookups.lookup_code = decode(l_information_code,'DK_COND_OF_EMP',hoi.org_information1,
													   'DK_EMP_GROUP',hoi.org_information2,NULL);

Line: 390

		 select segment2
		 from hr_soft_coding_keyflex
		 where soft_coding_keyflex_id = l_scl_id;

Line: 396

		select lookups.meaning
		from hr_organization_information hoi , hr_lookups lookups
		where hoi.organization_id = l_org_id
		and hoi.org_information_context = 'DK_EMPLOYMENT_DEFAULTS'
		and lookups.lookup_type = l_information_code
		and lookups.enabled_flag = 'Y'
		and lookups.lookup_code = decode(l_information_code,'DK_COND_OF_EMP',hoi.org_information1,
													   'DK_EMP_GROUP',hoi.org_information2,NULL);

Line: 406

		select business_group_id
		from hr_organization_units
		where organization_id = l_organization_id;

Line: 411

		select nvl(hoi.org_information1,'NO_DATA')
		from hr_organization_units hou , hr_organization_information hoi
		where hou.organization_id = l_organization_id
		and hou.organization_id = hoi.organization_id
		and hoi.org_information_context = 'CLASS'
		and hoi.org_information1 = 'HR_ORG';