DBA Data[Home] [Help]

APPS.PQH_EMPLOYEE_SALARY dependencies on FND_CURRENCIES

Line 36: l_precision Fnd_Currencies.Precision%type;

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: --
40: l_proc varchar2(72);

Line 100: From Fnd_Currencies Cur

96: and change_date <= p_Effective_Date);
97: --
98: Cursor csr_cur is
99: Select Nvl(Cur.Precision,2)
100: From Fnd_Currencies Cur
101: Where Cur.Currency_Code = P_currency;
102:
103: Begin
104: --

Line 378: From Fnd_Currencies Cur

374: RETURN NUMBER is
375: --
376: Cursor csr_cur is
377: Select Nvl(Cur.Precision,2)
378: From Fnd_Currencies Cur
379: Where Cur.Currency_Code = p_pgm_currency;
380: --
381: l_ret_amount number;
382: l_precision Fnd_Currencies.Precision%type;

Line 382: l_precision Fnd_Currencies.Precision%type;

378: From Fnd_Currencies Cur
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

Line 444: From Fnd_Currencies Cur

440: RETURN NUMBER is
441: --
442: Cursor csr_cur is
443: Select Nvl(Cur.Precision,2)
444: From Fnd_Currencies Cur
445: Where Cur.Currency_Code = p_pgm_currency;
446: --
447: l_ret_amount number;
448: l_precision Fnd_Currencies.Precision%type;

Line 448: l_precision Fnd_Currencies.Precision%type;

444: From Fnd_Currencies Cur
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;