DBA Data[Home] [Help]

APPS.PA_CURRENCY dependencies on PA_IMPLEMENTATIONS

Line 27: PA_IMPLEMENTATIONS IMP

23: l_sp,
24: l_ep
25: FROM FND_CURRENCIES FC,
26: GL_SETS_OF_BOOKS GB,
27: PA_IMPLEMENTATIONS IMP
28: WHERE FC.Currency_Code =
29: DECODE(IMP.Set_Of_Books_ID, Null, Null,GB.CURRENCY_CODE)
30: AND GB.Set_Of_Books_ID = IMP.Set_Of_Books_ID;
31: Else

Line 42: PA_IMPLEMENTATIONS_ALL IMP

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;

Line 86: PA_IMPLEMENTATIONS IMP

82: G_sp,
83: G_ep
84: FROM FND_CURRENCIES FC,
85: GL_SETS_OF_BOOKS GB,
86: PA_IMPLEMENTATIONS IMP
87: WHERE FC.Currency_Code =
88: DECODE(IMP.Set_Of_Books_ID, Null, Null,GB.CURRENCY_CODE)
89: AND GB.Set_Of_Books_ID = IMP.Set_Of_Books_ID;
90:

Line 306: PA_IMPLEMENTATIONS_ALL IMP

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);

Line 457: PA_IMPLEMENTATIONS IMP

453: l_sp,
454: l_ep
455: FROM FND_CURRENCIES FC,
456: GL_SETS_OF_BOOKS GB,
457: PA_IMPLEMENTATIONS IMP
458: WHERE FC.Currency_Code =
459: DECODE(IMP.Set_Of_Books_ID, Null, Null,GB.CURRENCY_CODE)
460: AND GB.Set_Of_Books_ID = IMP.Set_Of_Books_ID;
461: