DBA Data[Home] [Help]

APPS.PO_RETROACTIVE_PRICING_PVT dependencies on FND_CURRENCIES

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

3487: l_progress VARCHAR2(3);
3488: l_document_id NUMBER;
3489:
3490: -- Bug 3314204, Pass Inventory API price in functional price
3491: l_base_curr_precision FND_CURRENCIES.precision%TYPE := 2;
3492:
3493: CURSOR c_stdpo(p_po_header_id NUMBER) IS
3494: -- SQL What: Querying for standard PO which is not consigned
3495: -- SQL Why: Need to process retroactive price correction of

Line 3749: FROM FND_CURRENCIES FND,

3745:
3746: -- Bug 3314204, Pass Inventory API price in functional price
3747: SELECT nvl(FND.precision, 2)
3748: INTO l_base_curr_precision
3749: FROM FND_CURRENCIES FND,
3750: FINANCIALS_SYSTEM_PARAMETERS FSP,
3751: GL_SETS_OF_BOOKS GSB
3752: WHERE FSP.set_of_books_id = GSB.set_of_books_id AND
3753: FND.currency_code = GSB.currency_code;