eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_GSP_UTILITY dependencies on FND_CURRENCIES

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

2233:
2234: End Get_Emp_Los;
2235:
2236: Function Get_Currency
2237: (P_Corrency_Code In Fnd_Currencies_Vl.Currency_Code%TYPE)
2238:
2239: Return Varchar2 is
2240:
2241: Cursor Currency is

Line 2243: from Fnd_Currencies_Vl

2239: Return Varchar2 is
2240:
2241: Cursor Currency is
2242: Select Name
2243: from Fnd_Currencies_Vl
2244: Where Currency_Code = P_Corrency_Code
2245: and Enabled_Flag = 'Y';
2246:
2247: P_Currency_name Fnd_Currencies_Vl.Name%TYPE := NULL;

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

2243: from Fnd_Currencies_Vl
2244: Where Currency_Code = P_Corrency_Code
2245: and Enabled_Flag = 'Y';
2246:
2247: P_Currency_name Fnd_Currencies_Vl.Name%TYPE := NULL;
2248: begin
2249:
2250: If P_Corrency_Code is Not Null then
2251: open Currency;

Line 3993: Fnd_Currencies Cur

3989: Select Pgm.ACTY_REF_PERD_CD,
3990: Nvl(Cur.Precision,2),
3991: Update_Salary_Cd
3992: From Ben_Pgm_f Pgm,
3993: Fnd_Currencies Cur
3994: Where Pgm.Pgm_id = P_Pgm_Id
3995: and P_Effective_Date
3996: Between Pgm.Effective_Start_Date
3997: and Pgm.Effective_End_Date

Line 4011: l_precision Fnd_Currencies.Precision%TYPE;

4007: and Asg.Effective_End_Date
4008: and Ppb.Pay_Basis_Id = Asg.Pay_Basis_Id;
4009:
4010: l_ref_perd_cd Ben_Pgm_F.ACTY_REF_PERD_CD%TYPE;
4011: l_precision Fnd_Currencies.Precision%TYPE;
4012: l_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4013: l_ret_amount Number;
4014: l_pay_annualization_factor Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
4015: l_update_Salary_cd Ben_Pgm_F.Update_Salary_Cd%TYPE;