APPS.HR_NI_CHK_PKG SQL Statements

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

Line: 33

    select legislation_code
    from per_business_groups pbg
    where pbg.business_group_id = p_business_group_id;

Line: 186

   select formula_id
   from ff_compiled_info_f
   where formula_id = l_formula_id
   and p_session_date between effective_start_date and effective_end_date;

Line: 209

SELECT FORMULA_ID,EFFECTIVE_START_DATE
  into l_formula_id,l_effective_start_date
  FROM FF_FORMULAS_F fo, ff_formula_types ft
 WHERE  ft.formula_type_name = 'Oracle Payroll'
   and fo.formula_type_id = ft.formula_type_id
   and fo.FORMULA_NAME = 'NI_VALIDATION'
   AND fo.BUSINESS_GROUP_ID IS NULL
   AND fo.LEGISLATION_CODE = p_legislation_code
   AND p_session_date BETWEEN fo.EFFECTIVE_START_DATE AND fo.EFFECTIVE_END_DATE;

Line: 539

  SELECT org_information9
  INTO   l_legislation_code
  FROM   hr_organization_information
  WHERE  org_information_context = 'Business Group Information'
  AND    organization_id         = p_business_group_id;

Line: 554

     SELECT 'Y'
     INTO   l_status
     FROM   sys.dual
     WHERE  exists(SELECT '1'
		    FROM   per_all_people_f pp
		    WHERE (p_person_id IS NULL
		       OR  p_person_id <> pp.person_id)
		    AND    substr(p_national_identifier, 1, 8) = substr(pp.national_identifier, 1, 8)
		    AND    pp.business_group_id   +0 = p_business_group_id);

Line: 564

     SELECT 'Y'
     INTO   l_status
     FROM   sys.dual
     WHERE  exists(SELECT '1'
		    FROM   per_all_people_f pp
		    WHERE (p_person_id IS NULL
		       OR  p_person_id <> pp.person_id)
		    AND    p_national_identifier = pp.national_identifier
		    AND    pp.business_group_id   +0 = p_business_group_id);