38: l_sp,
39: l_ep
40: FROM FND_CURRENCIES FC,
41: GL_SETS_OF_BOOKS GB,
42: PA_IMPLEMENTATIONS_ALL IMP
43: WHERE FC.Currency_Code =
44: DECODE(IMP.Set_Of_Books_ID, Null, Null,GB.CURRENCY_CODE)
45: AND GB.Set_Of_Books_ID = IMP.Set_Of_Books_ID
46: AND IMP.org_id = G_org_id;
302: l_sp,
303: l_ep
304: FROM FND_CURRENCIES FC,
305: GL_SETS_OF_BOOKS GB,
306: PA_IMPLEMENTATIONS_ALL IMP
307: WHERE FC.Currency_Code =
308: DECODE(IMP.Set_Of_Books_ID, Null, Null,GB.CURRENCY_CODE)
309: AND GB.Set_Of_Books_ID = IMP.Set_Of_Books_ID
310: --AND nvl(IMP.Org_ID,-99) = nvl(X_Org_ID, -99);