APPS.HR_DK_VALIDATE_PKG SQL Statements

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

Line: 15

    SELECT 'Y'
    FROM   per_person_types ppt
    WHERE  ppt.system_person_type like 'EMP%'
    AND    ppt.person_type_Id = p_person_type_id;

Line: 194

        select business_group_id
        from hr_organization_units
        where organization_id = p_organization_id;

Line: 199

        select orgif.org_information1 from hr_organization_information orgif,hr_organization_units ou
        where  ( orgif.org_information_context = 'DK_SERVICE_PROVIDER_DETAILS' or orgif.org_information_context = 'DK_LEGAL_ENTITY_DETAILS')
        and    ou.organization_id = orgif.organization_id
        and    orgif.org_information1 = p_org_information1;

Line: 206

        select orgif.org_information1, orgif.org_information2, orgif.org_information3
	from   hr_organization_information orgif,hr_organization_units ou
        where  orgif.org_information_context = 'DK_SICKPAY_DEFAULTS'
        and    ou.business_group_id =  p_business_group_id
	and    ou.organization_id = p_organization_id
	and    ou.organization_id   = orgif.organization_id;

Line: 276

        select s.effective_date into l_effective_date from FND_SESSIONS s
            where s.session_id = userenv('sessionid');

Line: 295

 PROCEDURE validate_update_org_inf
  (p_org_info_type_code         in       varchar2
  ,p_org_information_id         in       number
  ,p_org_information1           in       varchar2
  ,p_org_information2           in       varchar2
  ,p_org_information3           in       varchar2
  ) IS

 l_org_information1  hr_organization_information.org_information1%TYPE;

Line: 323

 select business_group_id
 from hr_organization_units
 where organization_id = l_organization_id;

Line: 328

 select organization_id
 from hr_organization_information
 where org_information_id = p_org_information_id;

Line: 333

 select orgif.org_information1 from hr_organization_information orgif,hr_organization_units ou
 where  ( orgif.org_information_context = 'DK_SERVICE_PROVIDER_DETAILS' or orgif.org_information_context = 'DK_LEGAL_ENTITY_DETAILS')
 and ou.organization_id = orgif.organization_id
 and orgif.organization_id <> nvl(l_organization_id,0)
 and orgif.org_information1 = p_org_information1;

Line: 341

        select orgif.org_information1, orgif.org_information2, orgif.org_information3
	from   hr_organization_information orgif,hr_organization_units ou
        where  orgif.org_information_context = 'DK_SICKPAY_DEFAULTS'
        and    ou.business_group_id =  p_business_group_id
	and    ou.organization_id = p_organization_id
	and    ou.organization_id   = orgif.organization_id;

Line: 416

        select s.effective_date into l_effective_date from FND_SESSIONS s
            where s.session_id = userenv('sessionid');

Line: 432

END validate_update_org_inf;

Line: 434

  PROCEDURE validate_update_emp_asg
  (p_assignment_id                      in       number
  ,p_assignment_status_type_id          in number
  ,p_segment6           in      varchar2
  ,p_segment7           in      varchar2
  ,p_segment8           in      varchar2
  ,p_segment9           in      varchar2
  ) IS

  l_asg_start_date      date;

Line: 447

            select creation_date from per_all_assignments_f where
           assignment_id = p_assignment_id;

Line: 538

  END validate_update_emp_asg;

Line: 557

             select ou.internal_external_flag from hr_organization_units ou ,FND_SESSIONS s
             where ou.organization_id= p_organization_id
             and s.session_id = userenv('sessionid')
             and s.effective_date between ou.date_from and nvl(ou.date_to,to_date('31/12/4712','DD/MM/YYYY'));

Line: 566

          select count(hou.organization_id)
          from HR_ORGANIZATION_INFORMATION hoi
              ,HR_ORGANIZATION_UNITS hou
              ,FND_SESSIONS s
          where hoi.org_information_context ='CLASS'
          and hoi.org_information1 ='DK_SERVICE_PROVIDER'
          and hou.organization_id = hoi.organization_id
          and hou.BUSINESS_GROUP_ID = p_business_group_id
          and s.session_id = userenv('sessionid')
          and s.effective_date between hou.date_from and nvl(hou.date_to,to_date('31/12/4712','DD/MM/YYYY'));

Line: 578

        select business_group_id
        from hr_organization_units
        where organization_id = p_organization_id;