DBA Data[Home] [Help]

APPS.FV_FACTS_EDIT_CHECK dependencies on FV_PRECLOSING_AMOUNTS

Line 629: -- Bug 13102945: Fetch preclosing amounts from fv_preclosing_amounts instead of

625: init_vars;
626: v_edit_check_number := 7;
627:
628: -- Fetch preclosing ending balance for the treasury symbol
629: -- Bug 13102945: Fetch preclosing amounts from fv_preclosing_amounts instead of
630: -- fv_treasury_symbols
631: SELECT preclosing_unexpended_amt
632: INTO l_unexp_amount
633: FROM fv_preclosing_amounts

Line 633: FROM fv_preclosing_amounts

629: -- Bug 13102945: Fetch preclosing amounts from fv_preclosing_amounts instead of
630: -- fv_treasury_symbols
631: SELECT preclosing_unexpended_amt
632: INTO l_unexp_amount
633: FROM fv_preclosing_amounts
634: WHERE treasury_symbol_id = g_treasury_symbol_id;
635:
636: v_amount2 := l_unexp_amount;
637: create_log_record(v_log_text);

Line 975: FROM FV_PRECLOSING_AMOUNTS

971: AND set_of_books_id = l_set_of_books_id;*/
972:
973: SELECT NVL(PRECLOSING_SUBCLASS43_AMT, 0)
974: INTO l_subclass_amt
975: FROM FV_PRECLOSING_AMOUNTS
976: WHERE treasury_symbol_id = g_treasury_symbol_id
977: AND ledger_id = l_set_of_books_id;
978:
979: