APPS.PQH_GSP_UTILITY dependencies on FND_CURRENCIES

Line 2356: (P_Corrency_Code In Fnd_Currencies_Vl.Currency_Code%TYPE)

2352:
2353: End Get_Emp_Los;
2354:
2355: Function Get_Currency
2356: (P_Corrency_Code In Fnd_Currencies_Vl.Currency_Code%TYPE)
2357:
2358: Return Varchar2 is
2359:
2360: Cursor Currency is

Line 2362: from Fnd_Currencies_Vl

2358: Return Varchar2 is
2359:
2360: Cursor Currency is
2361: Select Name
2362: from Fnd_Currencies_Vl
2363: Where Currency_Code = P_Corrency_Code
2364: and Enabled_Flag = 'Y';
2365:
2366: P_Currency_name Fnd_Currencies_Vl.Name%TYPE := NULL;

Line 2366: P_Currency_name Fnd_Currencies_Vl.Name%TYPE := NULL;

2362: from Fnd_Currencies_Vl
2363: Where Currency_Code = P_Corrency_Code
2364: and Enabled_Flag = 'Y';
2365:
2366: P_Currency_name Fnd_Currencies_Vl.Name%TYPE := NULL;
2367: begin
2368:
2369: If P_Corrency_Code is Not Null then
2370: open Currency;

Line 4112: Fnd_Currencies Cur

4108: Select Pgm.ACTY_REF_PERD_CD,
4109: Nvl(Cur.Precision,2),
4110: Update_Salary_Cd
4111: From Ben_Pgm_f Pgm,
4112: Fnd_Currencies Cur
4113: Where Pgm.Pgm_id = P_Pgm_Id
4114: and P_Effective_Date
4115: Between Pgm.Effective_Start_Date
4116: and Pgm.Effective_End_Date

Line 4130: l_precision Fnd_Currencies.Precision%TYPE;

4126: and Asg.Effective_End_Date
4127: and Ppb.Pay_Basis_Id = Asg.Pay_Basis_Id;
4128:
4129: l_ref_perd_cd Ben_Pgm_F.ACTY_REF_PERD_CD%TYPE;
4130: l_precision Fnd_Currencies.Precision%TYPE;
4131: l_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4132: l_ret_amount Number;
4133: l_pay_annualization_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4134: l_update_Salary_cd Ben_Pgm_F.Update_Salary_Cd%TYPE;