APPS.PER_PERRPPSM_XMLP_PKG SQL Statements

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

Line: 26

  select  peo.first_name ||
	  decode(peo.first_name,null,null,' ') ||
          peo.last_name
  into    v_name
  from    per_all_people_f peo
  where  peo.person_id = p_person_id
  and  p_session_date between peo.effective_start_date
                       and     peo.effective_end_date;

Line: 40

  select org_information10
  into c_currency_code
  from hr_organization_information
  where organization_id = p_business_group_id
  and org_information_context = 'Business Group Information';

Line: 189

if c_address7 = 'GB' and c_address5 is not null then      select meaning
     into c_address5
     from fnd_common_lookups
     where lookup_type = 'GB_COUNTY'
     and lookup_code = c_address5;

Line: 346

select count(*)
into v_count
from   pay_personal_payment_methods_f ppm
,      pay_org_payment_methods_f opm
,      pay_payment_types pt
where  ppm.business_group_id = p_business_group_id
and    ppm.assignment_id = p_assignment_id
and    p_session_date between ppm.effective_start_date
		       and     ppm.effective_end_date
and    p_session_date between opm.effective_start_date
                       and     opm.effective_end_date
and    ppm.org_payment_method_id = opm.org_payment_method_id
and    opm.payment_type_id = pt.payment_type_id;