APPS.PQH_EMPLOYEE_SALARY dependencies on PER_PAY_BASES

Line 35: l_basis_Annl_fctr Per_Pay_Bases.Pay_Annualization_Factor%TYPE;

31: --
32: l_pay_basis_id Per_All_Assignments_f.pay_basis_id%type;
33: l_pgm_id Per_All_Assignments_f.GRADE_LADDER_PGM_ID%type;
34: l_payroll_id Per_All_Assignments_f.payroll_id%type;
35: l_basis_Annl_fctr Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
36: l_precision Fnd_Currencies.Precision%type;
37: L_Salary pay_element_entry_values_f.screen_entry_value%TYPE;
38: --
39: --

Line 71: From Per_Pay_Bases paf

67: Between pet.effective_start_date and pet.effective_end_date;
68: --
69: Cursor Pay_Bases_Element is
70: Select input_value_id, Pay_Annualization_Factor,pay_basis
71: From Per_Pay_Bases paf
72: Where paf.pay_basis_id = l_pay_basis_id;
73: --
74: Cursor GrdLdr_Element is
75: Select DFLT_INPUT_VALUE_ID

Line 383: l_pay_annualization_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;

379: Where Cur.Currency_Code = p_pgm_currency;
380: --
381: l_ret_amount number;
382: l_precision Fnd_Currencies.Precision%type;
383: l_pay_annualization_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
384: l_proc varchar2(72);
385: --
386: Begin
387: --

Line 449: l_pay_annualization_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;

445: Where Cur.Currency_Code = p_pgm_currency;
446: --
447: l_ret_amount number;
448: l_precision Fnd_Currencies.Precision%type;
449: l_pay_annualization_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
450: l_proc varchar2(72);
451:
452: l_pay_basis_id number;
453:

Line 492: from per_pay_bases ppb

488: and P_Effective_Date
489: Between Paf.Effective_Start_Date and Paf.Effective_End_Date;
490:
491: select PAY_ANNUALIZATION_FACTOR into l_PAY_ANNUALIZATION_FACTOR
492: from per_pay_bases ppb
493: where PAY_BASIS_ID = l_pay_basis_id;
494: End if;
495: --
496: l_ret_amount := (p_amount * l_pay_annualization_factor);

Line 595: From Per_Pay_Bases ppb

591: and change_date = p_change_dt;
592: --
593: CURSOR C_Pay_Basis IS
594: select name, pay_basis
595: From Per_Pay_Bases ppb
596: where Ppb.Pay_Basis_Id = l_pay_basis_id;
597:
598: Begin
599: --