APPS.PER_PAY_PROPOSALS_POPULATE SQL Statements

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

Line: 22

    SELECT fnd_number.canonical_to_number(PGR.MINIMUM)
    ,      fnd_number.canonical_to_number(PGR.MAXIMUM)
    ,      fnd_number.canonical_to_number(PGR.MID_VALUE)
    ,      PRV.RATE_UOM
    FROM   PER_PAY_BASES PPB
    ,      PAY_GRADE_RULES_F PGR
    ,      PAY_RATES_V PRV
    ,      PER_ALL_ASSIGNMENTS_F ASG
    WHERE  ASG.ASSIGNMENT_ID=p_assignment_id
    AND    PPB.PAY_BASIS_ID=ASG.PAY_BASIS_ID
    AND    PPB.RATE_ID=PGR.RATE_ID
    AND    PPB.RATE_ID=PRV.RATE_ID
    AND    ASG.GRADE_ID=PGR.GRADE_OR_SPINAL_POINT_ID
    AND    p_date BETWEEN asg.effective_start_date
                  AND     asg.effective_end_date
    AND    p_date BETWEEN pgr.effective_start_date
                  AND     pgr.effective_end_date;

Line: 41

    SELECT GRA.NAME
    FROM   PER_GRADES_VL GRA
    ,      PER_ALL_ASSIGNMENTS_F ASG
    WHERE  ASG.ASSIGNMENT_ID=p_assignment_id
    AND    ASG.GRADE_ID=GRA.GRADE_ID
    AND    p_date BETWEEN asg.effective_start_date
                  AND     asg.effective_end_date;

Line: 81

 select fnd_number.canonical_to_number(pev.screen_entry_value)
   ,      pee.element_entry_id
   from   pay_element_entry_values_f pev
   ,      pay_element_entries_f pee
   ,      per_pay_bases ppb
   ,      per_all_assignments_f asg
   where  asg.assignment_id=p_assignment_id
   and    NVL(p_change_date,to_date('31-12-4127','DD-MM-YYYY')) between
          asg.effective_start_date and asg.effective_end_date
   and    NVL(p_change_date,to_date('31-12-4127','DD-MM-YYYY')) between
          pev.effective_start_date and pev.effective_end_date
   and    pev.element_entry_id=pee.element_entry_id
   and    asg.assignment_id=pee.assignment_id
   and    NVL(p_change_date,to_date('31-12-4127','DD-MM-YYYY')) between
          pee.effective_start_date and pee.effective_end_date
   and    pev.input_value_id+0=ppb.input_value_id
   and    asg.pay_basis_id=ppb.pay_basis_id
   -- the below line added for bug Fix# 3192448
   and    pee.creator_type = 'SP';

Line: 174

  select business_group_id
  from   per_all_assignments_f
  where  assignment_id=p_assignment_id
  and    p_date BETWEEN
         effective_start_date AND
         effective_end_date;

Line: 293

  SELECT PAF.PAY_BASIS_ID
  FROM PER_ALL_ASSIGNMENTS_F        PAF
  WHERE PAF.ASSIGNMENT_ID=p_assignment_id
  AND p_effective_date  BETWEEN
  PAF.EFFECTIVE_START_DATE AND
  PAF.EFFECTIVE_END_DATE;

Line: 301

  SELECT PET.INPUT_CURRENCY_CODE
, PPB.NAME
, HR_GENERAL.DECODE_LOOKUP('PAY_BASIS',PPB.PAY_BASIS)
, PPB.PAY_ANNUALIZATION_FACTOR
, PPB.GRADE_ANNUALIZATION_FACTOR
, PPB.PAY_BASIS
, PPB.RATE_BASIS
, PET.ELEMENT_TYPE_ID
, PIV.UOM
  FROM PAY_ELEMENT_TYPES_F PET
, PAY_INPUT_VALUES_F       PIV
, PER_PAY_BASES            PPB
--
  WHERE PPB.PAY_BASIS_ID=L_PAY_BASIS_ID
--
  AND PPB.INPUT_VALUE_ID=PIV.INPUT_VALUE_ID
  AND p_effective_date  BETWEEN
  PIV.EFFECTIVE_START_DATE AND
  PIV.EFFECTIVE_END_DATE
--
  AND PIV.ELEMENT_TYPE_ID=PET.ELEMENT_TYPE_ID
  AND p_effective_date  BETWEEN
  PET.EFFECTIVE_START_DATE AND
  PET.EFFECTIVE_END_DATE;

Line: 384

      select pro.proposed_salary_n
      ,      pro.change_date
      from per_pay_proposals pro
      where pro.assignment_id = p_assignment_id
      and pro.change_date =(select max(pro2.change_date)
                            from per_pay_proposals pro2
                            where pro2.assignment_id = p_assignment_id
                            and pro2.change_date

  select prl.payroll_name
  ,      tpt.number_per_fiscal_year
  from pay_all_payrolls_f prl
  ,    per_all_assignments_f paf
  ,    per_time_period_types tpt
  where paf.assignment_id=p_assignment_id
  and p_date between paf.effective_start_date
      and paf.effective_end_date
  and paf.payroll_id=prl.payroll_id
  and p_date between prl.effective_start_date
      and prl.effective_end_date
  and prl.period_type = tpt.period_type(+);

  select asg.normal_hours
  ,      decode(asg.frequency
               ,'Y',1
               ,'M',12
               ,'W',52
               ,'D',365
               ,1)
  from   per_all_assignments_f asg
  where  asg.assignment_id =p_assignment_id
  and    p_date between asg.effective_start_date
         and asg.effective_end_date;

  select pos.working_hours
  ,      decode(pos.frequency
               ,'Y',1
               ,'M',12
               ,'W',52
               ,'D',365
               ,1)
  from   hr_all_positions pos
  ,      per_all_assignments_f asg
  where  asg.assignment_id =p_assignment_id
  and    p_date between asg.effective_start_date
         and asg.effective_end_date
  and    asg.position_id=pos.position_id;

  select fnd_number.canonical_to_number(org.org_information3) normal_hours
  ,      decode(org.org_information4
               ,'Y',1
               ,'M',12
               ,'W',52
               ,'D',365
               ,1)
  from   HR_ORGANIZATION_INFORMATION org
  ,      per_all_assignments_f asg
  where  asg.assignment_id =p_assignment_id
  and    p_date between asg.effective_start_date
         and asg.effective_end_date
  and    asg.organization_id=org.organization_id(+)
  and    org.org_information_context(+) = 'Work Day Information';

  select fnd_number.canonical_to_number(bus.working_hours) normal_hours
  ,      decode(bus.frequency
               ,'Y',1
               ,'M',12
               ,'W',52
               ,'D',365
               ,1)
  from   per_business_groups bus
  ,      per_all_assignments_f asg
  where  asg.assignment_id =p_assignment_id
  and    p_date between asg.effective_start_date
         and asg.effective_end_date
  and    asg.business_group_id=bus.business_group_id;