DBA Data[Home] [Help]

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 517: From Per_Pay_Bases ppb

513: and change_date = p_change_dt;
514: --
515: CURSOR C_Pay_Basis IS
516: select name, pay_basis
517: From Per_Pay_Bases ppb
518: where Ppb.Pay_Basis_Id = l_pay_basis_id;
519:
520: Begin
521: --