DBA Data[Home] [Help]

APPS.PSA_BC_XML_REPORT_PUB dependencies on FV_TREASURY_SYMBOLS

Line 516: Type get_tsymbol IS TABLE OF FV_TREASURY_SYMBOLS.TREASURY_SYMBOL%TYPE INDEX BY VARCHAR2(30);

512: l_summary_used VARCHAR2(1);
513: l_event_id NUMBER;
514:
515: -- Bug 5711972
516: Type get_tsymbol IS TABLE OF FV_TREASURY_SYMBOLS.TREASURY_SYMBOL%TYPE INDEX BY VARCHAR2(30);
517: rc_tsymbol get_tsymbol;
518:
519: -- Populate Tab is used since BULK Collect Overwrites the current collection.
520: -- Since we do not have an APPEND clause in BULK COLLECT, we have used 2

Line 557: FROM fv_treasury_symbols

553: ELSE
554: BEGIN
555: SELECT treasury_symbol
556: INTO l_treasury_symbol
557: FROM fv_treasury_symbols
558: WHERE treasury_symbol_id in (SELECT treasury_symbol_id
559: FROM fv_fund_parameters
560: WHERE fund_value = l_fund_value
561: AND set_of_books_id = p_para_rec.ledger_id)