APPS.HR_PL_UTILITY SQL Statements

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

Line: 50

        SELECT SUBSTR(LTRIM(RTRIM(
              DECODE(p_last_name, NULL, '',p_last_name)
              ||DECODE(p_first_name,NULL, '',' ' || p_first_name)
              ||DECODE(p_middle_names,NULL, '', ' ' || p_middle_names)
              ||DECODE(p_title,NULL, '', ' ' || p_title)
              )), 1, 240)
        INTO   l_full_name
        FROM   dual;

Line: 108

         SELECT SUBSTR(LTRIM(RTRIM(
              DECODE(p_last_name, NULL, '',p_last_name)
              ||DECODE(p_first_name,NULL, '',' ' || p_first_name)
              ||DECODE(p_middle_names,NULL, '', ' ' || p_middle_names)
              ||DECODE(p_title,NULL, '', ' ' || p_title)
              )), 1, 240)
        INTO   l_order_name
        FROM   dual;

Line: 189

      select per_information1
        from per_all_people_f ppf
       where ppf.business_group_id = p_business_group_id
         and ppf.person_id <> nvl (p_person_id, 0)
         and ppf.per_information1 = p_nip_number
         and ppf.per_information7 = p_legal_employer
         and ppf.nationality      = 'PQH_PL'
         and ppf.per_information8 = 'PL' ;

Line: 669

  select   ppj.start_date, ppj.end_date,
           ppj.period_years, ppj.period_months,
           ppj.period_days
     from  per_previous_jobs ppj, per_previous_employers ppe
     where ppe.person_id            = P_PERSON_ID
	 and   ppe.previous_employer_id = ppj.previous_employer_id
	 and   ppj.PJO_INFORMATION1  = P_TYPE_OF_SERVICE    -- Replaced with PJO_INFORMATION1
     and   ppj.start_date IS NOT NULL
     AND   ppj.end_date IS NOT NULL
     order by ppj.start_date, ppj.end_date;

Line: 681

  select   ppj.start_date, ppj.end_date,
           ppj.period_years, ppj.period_months,
           ppj.period_days
     from  per_previous_jobs ppj, per_previous_employers ppe
     where ppe.person_id            = P_PERSON_ID
	 and   ppe.previous_employer_id = ppj.previous_employer_id
	 and   ppj.PJO_INFORMATION1  = P_TYPE_OF_SERVICE    -- Replaced with PJO_INFORMATION1
     and   ppj.start_date IS NULL
     AND   ppj.end_date IS NULL ;

Line: 692

    select description
    from   hr_lookups       -- Replaced with hr_lookups
    where  lookup_type = lookup_type_val
    and    lookup_code = P_TYPE_OF_SERVICE
    and    description in (lookup_descr_val1, lookup_descr_val2);

Line: 731

   select fnd_message.get_string(message_cat,message_name)
   from dual;

Line: 936

select  lookup_code
          from   hr_lookups
          where LOOKUP_TYPE='PL_CONTRIBUTION_TYPE'
          and   lookup_code=P_ENTRY_VALUE;

Line: 960

  Cursor csr_vehicle is select
	puci.value,
	pvrf.engine_capacity_in_cc,
	pvrf.vehicle_type,
	pvaf.val_information3
from
	 pqp_vehicle_allocations_f pvaf,
	 pay_user_column_instances_f puci,
	 pqp_vehicle_repository_f pvrf
where
    pvaf.val_information2 = puci.user_column_instance_id and
    pvaf.vehicle_repository_id = pvrf.vehicle_repository_id and
    pvaf.vehicle_allocation_id = p_vehicle_allocation_id and
    p_date_earned between pvaf.effective_start_date and pvaf.effective_end_date and
    p_date_earned between pvrf.effective_start_date and pvrf.effective_end_date and
    p_date_earned between puci.effective_start_date and puci.effective_end_date;

Line: 1003

select person_id
from   per_all_assignments_f
where  assignment_id=p_assignment_id;

Line: 1008

select date_start start_date,nvl(ACTUAL_TERMINATION_DATE ,p_date) end_date
from per_periods_of_service
where person_id=r_person_id;

Line: 1013

 select nvl(period_months,0) months,nvl(period_days,0) days,nvl(period_years,0) years
 from   PER_PREVIOUS_EMPLOYERS
 where  person_id=r_person_id
 and    employer_type='PREVIOUS'
 and    start_date is  null;

Line: 1020

 select start_date ,end_date,period_months,period_days,period_years,employer_type
 from   PER_PREVIOUS_EMPLOYERS
 where  person_id=r_person_id
 and employer_type in ('PREVIOUS','PARALLEL')
 and start_date is not null
 and start_date

     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
            AND    pp.per_information7 = p_legal_employer);