DBA Data[Home] [Help]

APPS.PO_RETROACTIVE_PRICING_PVT dependencies on FND_CURRENCIES

Line 3370: l_base_curr_precision FND_CURRENCIES.precision%TYPE := 2;

3366: l_progress VARCHAR2(3);
3367: l_document_id NUMBER;
3368:
3369: -- Bug 3314204, Pass Inventory API price in functional price
3370: l_base_curr_precision FND_CURRENCIES.precision%TYPE := 2;
3371:
3372: CURSOR c_stdpo(p_po_header_id NUMBER) IS
3373: -- SQL What: Querying for standard PO which is not consigned
3374: -- SQL Why: Need to process retroactive price correction of

Line 3628: FROM FND_CURRENCIES FND,

3624:
3625: -- Bug 3314204, Pass Inventory API price in functional price
3626: SELECT nvl(FND.precision, 2)
3627: INTO l_base_curr_precision
3628: FROM FND_CURRENCIES FND,
3629: FINANCIALS_SYSTEM_PARAMETERS FSP,
3630: GL_SETS_OF_BOOKS GSB
3631: WHERE FSP.set_of_books_id = GSB.set_of_books_id AND
3632: FND.currency_code = GSB.currency_code;