APPS.PQH_EMPLOYEE_SALARY SQL Statements

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

Line: 43

  Select paf.pay_basis_id, paf.GRADE_LADDER_PGM_ID, paf.payroll_id,paf.business_group_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: 50

  Select pev.screen_entry_value,pet.INPUT_CURRENCY_CODE
    From pay_element_entries_f pee,
         pay_input_values_f piv,
         pay_element_entry_values_f pev,
         pay_element_types_f pet
   Where pee.Assignment_id = P_Assignment_id
     and P_Effective_Date
 between pee.Effective_Start_Date and pee.Effective_End_Date
     and Piv.Input_Value_id   = l_Input_Value_id
     and P_Effective_Date
 Between Piv.Effective_Start_Date and Piv.Effective_End_Date
     and pev.ELEMENT_ENTRY_ID = Pee.ELEMENT_ENTRY_ID
     and Piv.INPUT_VALUE_ID = Pev.INPUT_VALUE_ID
     and P_Effective_Date
 Between Pev.Effective_Start_Date and Pev.Effective_End_Date
     and pet.element_type_id = piv.element_type_id
     and p_effective_date
 Between pet.effective_start_date and pet.effective_end_date;

Line: 70

  Select input_value_id, Pay_Annualization_Factor,pay_basis
    From Per_Pay_Bases paf
   Where paf.pay_basis_id  = l_pay_basis_id;

Line: 75

  Select DFLT_INPUT_VALUE_ID
    from Ben_Pgm_f             pgm
   Where pgm.pgm_id = l_pgm_id
     and p_Effective_Date
 Between pgm.Effective_Start_date and pgm.Effective_End_Date;

Line: 82

  Select pr.period_type, (p_sal * pt.number_per_fiscal_year) annual_salary
    From per_time_period_types pt, pay_all_payrolls_f pr
  Where pr.payroll_id = p_payroll_id
    and p_Effective_Date
Between pr.Effective_Start_date and pr.Effective_End_Date
    and pr.period_type = pt.period_type;

Line: 90

 select proposal_reason
   from per_pay_proposals
  where assignment_id = p_assignment_id
   and change_date = (Select max(change_date)
                        From per_pay_proposals
                       where assignment_id = p_assignment_id
                         and change_date <= p_Effective_Date);

Line: 99

 Select Nvl(Cur.Precision,2)
  From  Fnd_Currencies Cur
  Where Cur.Currency_Code = P_currency;

Line: 298

Select 'x'
 from ben_pgm_f
 Where business_group_id = p_business_group_id
   and pgm_typ_cd  = 'GSP'
   and p_effective_date between effective_start_date and effective_end_date;

Line: 377

 Select Nvl(Cur.Precision,2)
  From  Fnd_Currencies Cur
  Where Cur.Currency_Code = p_pgm_currency;

Line: 443

 Select Nvl(Cur.Precision,2)
  From  Fnd_Currencies Cur
  Where Cur.Currency_Code = p_pgm_currency;

Line: 485

        select PAY_BASIS_ID into l_pay_basis_id
        from per_all_assignments_f paf
        where ASSIGNMENT_ID = P_Assignment_id
        and P_Effective_Date
        Between Paf.Effective_Start_Date and Paf.Effective_End_Date;

Line: 491

        select  PAY_ANNUALIZATION_FACTOR  into l_PAY_ANNUALIZATION_FACTOR
        from per_pay_bases ppb
        where PAY_BASIS_ID = l_pay_basis_id;

Line: 532

l_update_sal_cd   ben_pgm_f.update_salary_cd%type;

Line: 546

  Select paf.pay_basis_id, paf.GRADE_LADDER_PGM_ID, paf.person_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: 553

  Select ACTY_REF_PERD_CD,pgm_uom,Update_Salary_Cd
    from Ben_Pgm_f pgm
   Where pgm.pgm_id = l_pgm_id
     and p_Effective_Date
 Between pgm.Effective_Start_date and pgm.Effective_End_Date;

Line: 560

 Select max(pil.Per_in_Ler_Id)
   From Ben_Per_in_ler PIL,
        Ben_Ler_F LER
  Where Pil.Ler_Id = LER.Ler_Id
    And Pil.LF_EVT_OCRD_DT = P_Effective_Date
    And ler.typ_Cd = 'GSP'
    And Pil.person_Id = l_person_id
    And Pil.Per_In_Ler_Stat_Cd = 'PROCD';

Line: 570

 Select Rate.Val Proposed_Sal,
        Rate.Rt_Strt_Dt Sal_Chg_Dt
   From Ben_Elig_Per_Elctbl_Chc Elct,
        Ben_Enrt_Rt Rate
  Where Elct.DFLT_FLAG = 'Y'
    and Elct.Elctbl_Flag = 'Y'
    and Elct.Per_in_ler_id = l_per_in_ler_id
    and Elct.Enrt_Cvg_Strt_Dt is Not NULL
    And Rate.ELIG_PER_ELCTBL_CHC_ID(+) = Elct.ELIG_PER_ELCTBL_CHC_ID;

Line: 581

  Select pr.period_type
    From pay_all_payrolls_f pr
  Where pr.payroll_id = p_payroll_id
    and p_Effective_Date
Between pr.Effective_Start_date and pr.Effective_End_Date;

Line: 588

 select proposal_reason
   from per_pay_proposals
  where assignment_id = p_assignment_id
   and change_date = p_change_dt;

Line: 594

 select name, pay_basis
   From Per_Pay_Bases ppb
  where Ppb.Pay_Basis_Id = l_pay_basis_id;

Line: 625

        Fetch csr_GrdLdr into l_pgm_frequency, p_currency, l_update_sal_cd;

Line: 630

        If l_update_sal_cd in ('SALARY_BASIS','SALARY_ELEMENT') then
          --
          Open csr_le;

Line: 654

             If l_update_sal_cd = 'SALARY_BASIS' then
              --
              If l_pay_basis_id IS NOT NULL then
                --
                hr_utility.set_location('Assignment has Salary Basis', 50);

Line: 694

             End if; /** l_update_salary_cd = 'SALARY BASIS' **/

Line: 724

           hr_utility.set_location('Grade Ladder setup to not update salary', 120);