DBA Data[Home] [Help]

APPS.FV_FACTS2_DERIVE_BALANCES dependencies on FV_TREASURY_SYMBOLS

Line 658: p_treasury_symbol_id OUT NOCOPY fv_treasury_symbols.treasury_symbol_id%TYPE,

654: PROCEDURE get_treasury_info
655: (
656: p_ledger_id IN NUMBER,
657: p_fund_value IN VARCHAR2,
658: p_treasury_symbol_id OUT NOCOPY fv_treasury_symbols.treasury_symbol_id%TYPE,
659: p_cohort_segment OUT NOCOPY VARCHAR2,
660: p_error_code OUT NOCOPY NUMBER,
661: p_error_desc OUT NOCOPY VARCHAR2
662: )

Line 685: fv_treasury_symbols fts,

681: ffa.cohort_segment_name
682: INTO p_treasury_symbol_id,
683: p_cohort_segment
684: FROM fv_fund_parameters fp,
685: fv_treasury_symbols fts,
686: fv_facts_federal_accounts ffa
687: WHERE fp.set_of_books_id = p_ledger_id
688: AND fp.fund_value = p_fund_value
689: AND fts.treasury_symbol_id = fp.treasury_symbol_id