APPS.HR_SCL_FLEX SQL Statements

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

Line: 47

        select htu.business_group_id
        from   HR_TAX_UNITS_V htu
        where  htu.tax_unit_id = p_segment1;

Line: 129

        select peo.business_group_id
        from   per_people_f peo
        ,      per_assignments_f asg
        where  peo.person_id = asg.person_id
        and    asg.assignment_type = 'E'
        and    peo.person_id = p_segment2
        and    p_validation_start_date between peo.effective_start_date
				  and peo.effective_end_date
        and    p_validation_start_date between asg.effective_start_date
				  and asg.effective_end_date;

Line: 221

        select null
        from   FND_COMMON_LOOKUPS lu
        where  lu.lookup_type = 'YES_NO'
        and    lu.lookup_code = p_segment3;

Line: 287

    select null
      from pay_user_columns puc
          ,hr_organization_information hoi
     where (  to_char(puc.user_table_id) = hoi.org_information1
           or hoi.org_information1 is null)
       and puc.user_column_id = to_number(p_segment4)
       and hoi.org_information_context = 'Work Schedule'
       and hoi.organization_id = p_organization_id;

Line: 360

        select null
        from   FND_COMMON_LOOKUPS lu
        where  lu.lookup_type = 'US_SHIFTS'
        and    lu.lookup_code = p_segment5
        and    lu.application_id = 800;

Line: 492

        select null
        from   FND_COMMON_LOOKUPS lu
        where  lu.lookup_type = 'YES_NO'
        and    lu.lookup_code = p_segment7;

Line: 555

   Select null
   From PAY_WC_RATES wcr,
	PAY_WC_FUNDS wcf,
	HR_ORGANIZATION_INFORMATION org,
	PAY_EMP_FED_TAX_V1 ftr
   where wcr.fund_id = wcf.fund_id
   and
   (
     ( wcf.location_id is null
	and not exists
 	  (
	   select 1
	   from pay_wc_rates wcr1,
	        pay_wc_funds wcf1
	   where wcr1.wc_code = wcr.wc_code
	   and     wcr1.fund_id = wcf1.fund_id
	   and     wcf1.location_id = p_location_id
	   and     wcf1.state_code = ftr.sui_state_code
	   and     wcf1.carrier_id = org.org_information8 )
	  )
	OR
	  ( wcf.location_id is not null
	     AND wcf.location_id = p_location_id
	  )
	)
	AND wcf.carrier_id = org.org_information8
	AND  org.org_information1 = ftr.sui_state_code
	AND  org.org_information_context = 'State Tax Rules'
	AND  org.organization_id = p_segment1
	AND   wcf.state_code = ftr.sui_state_code
	AND   ftr.assignment_id = p_assignment_id
	AND   wcr.wc_code = p_segment8;

Line: 658

	select est.business_group_id
	from   HR_ESTABLISHMENTS_V est
        where  est.establishment_id = p_segment9;

Line: 890

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