APPS.PAY_US_VALIDATE_INFO SQL Statements

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

Line: 20

	select hoi.org_information1
	into l_trans_flag
	from HR_ORGANIZATION_INFORMATION hoi
	where hoi.org_information_context = p_context
	and   hoi.org_information1	      = 'Y'
    and exists (select null
    		    from hr_organization_information hoi1
	    	    where hoi1.organization_id = hoi.organization_id
                and  hoi1.org_information_context = 'CLASS'
                and hoi1.org_information1 = 'HR_LEGAL'
                and hoi1.org_information2 = 'Y')
	and  exists (select hou.organization_id
			from HR_ORGANIZATION_UNITS hou
			where hou.organization_id = hoi.organization_id
			and hou.business_group_id = p_business_group_id);

Line: 55

	select distinct hoi.org_information2,
			hoi.org_information3
	from HR_ORGANIZATION_INFORMATION hoi
	where hoi.org_information_context = p_context
    and exists (select null
	        from hr_organization_information hoi1
		    where hoi1.organization_id = hoi.organization_id
            and  hoi1.org_information_context = 'CLASS'
            and hoi1.org_information1 = 'HR_ESTAB'
            and hoi1.org_information2 = 'Y')
	and  exists (select hou.organization_id
			from HR_ORGANIZATION_UNITS hou
			where hou.organization_id = hoi.organization_id
			and hou.business_group_id = p_business_group_id);

Line: 102

	  select hoi.organization_id
	  into   l_organization_id
	  from   HR_ORGANIZATION_INFORMATION hoi
	  where  hoi.org_information2 = l_sui_no
	  and    hoi.org_information3 = l_run
	  and    hoi.org_information1 = 'Y'
          and    hoi.org_information_context = p_context
	  and  exists (select hou.organization_id
			from HR_ORGANIZATION_UNITS hou
			where hou.organization_id = hoi.organization_id
			and hou.business_group_id = p_business_group_id);