APPS.PSA_BC_XML_REPORT_PUB dependencies on FV_TREASURY_SYMBOLS

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

532: l_summary_used VARCHAR2(1);
533: l_event_id NUMBER;
534:
535: -- Bug 5711972
536: Type get_tsymbol IS TABLE OF FV_TREASURY_SYMBOLS.TREASURY_SYMBOL%TYPE INDEX BY VARCHAR2(30);
537: rc_tsymbol get_tsymbol;
538:
539: -- Populate Tab is used since BULK Collect Overwrites the current collection.
540: -- Since we do not have an APPEND clause in BULK COLLECT, we have used 2

Line 584: FROM fv_treasury_symbols

580: ELSE
581: BEGIN
582: SELECT treasury_symbol
583: INTO l_treasury_symbol
584: FROM fv_treasury_symbols
585: WHERE treasury_symbol_id in (SELECT treasury_symbol_id
586: FROM fv_fund_parameters
587: WHERE fund_value = l_fund_value
588: AND set_of_books_id = p_para_rec.ledger_id)