APPS.PAY_FR_TERMINATION_PKG SQL Statements

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

Line: 72

select assign.business_group_id,
       assign.assignment_id,
       assign.effective_start_date,
       assign.effective_end_date,
       -- Modified as part of time analysis changes
       -- normal_hours,
       -- frequency,
       decode(contract.ctr_information12, 'HOUR', fnd_number.canonical_to_number(contract.ctr_information11), assign.normal_hours) normal_hours,
       decode(contract.ctr_information12, 'HOUR', contract.ctr_information13, assign.frequency) frequency,
       --
       assign.establishment_id,
       assign.period_of_service_id,
       substr(hruserdt.get_table_value (assign.business_group_id,'FR_CIPDZ','CIPDZ',assign.employment_category,P_termination_date),1,1) part_time_flag
from
       per_all_assignments_f assign,
       --
       per_contracts_f       contract
where  assign.person_id = c_person_id
  --
  and  assign.contract_id = contract.contract_id
  --
order by  assign.effective_start_date;

Line: 97

select to_number(org_information3) monthly_hours,
       fnd_date.canonical_to_date(org_information1) date_from,
       fnd_date.canonical_to_date(org_information2) date_to
from
       hr_organization_information
where
       org_information_context = 'FR_HISTORICAL_MONTHLY_REF_HRS'
       and organization_id = c_org_id
order by fnd_date.canonical_to_date(org_information1);

Line: 288

  select distinct person_id
  into l_person_id
  from per_all_assignments_f
  where assignment_id = p_assignment_id
  and business_group_id = p_business_group_id;

Line: 294

  select min(start_date)
  into l_hire_date
  from per_all_people_f
  where person_id = l_person_id;

Line: 332

  Select fnd_date.canonical_to_date(pds_information10)
  into
  l_last_day_worked
  from per_periods_of_service
  where period_of_service_id = l_period_of_service_id;

Line: 345

     select to_number(org_information4)
     into   l_current_monthly_ref_hours
     from   hr_organization_information
     where  org_information_context = 'FR_ESTAB_INFO'
       and organization_id      = l_assignments(i).establishment_id;

Line: 350

        l_monthly_hours.delete;