DBA Data[Home] [Help]

APPS.FV_FACTS_EDIT_CHECK dependencies on FV_TREASURY_SYMBOLS

Line 622: FROM fv_treasury_symbols

618:
619: --Fetch preclosing ending balance for the treasury symbol
620: SELECT preclosing_unexpended_amt
621: INTO l_unexp_amount
622: FROM fv_treasury_symbols
623: WHERE treasury_symbol_id = g_treasury_symbol_id;
624:
625: v_amount2 := l_unexp_amount;
626: create_log_record(v_log_text);

Line 1206: from fv_treasury_symbols

1202: --Fetch 224 Outlays
1203: select decode(p_facts_run_quarter,1,sf224_qtr1_outlay,
1204: 2,sf224_qtr2_outlay,3,sf224_qtr3_outlay,sf224_qtr4_outlay)
1205: into l_224_outlays
1206: from fv_treasury_symbols
1207: where treasury_symbol_id = g_treasury_symbol_id;
1208:
1209: IF (l_224_outlays is NULL) THEN
1210:

Line 1323: FROM fv_treasury_symbols

1319: g_treasury_symbol_id := p_treasury_symbol_id;
1320:
1321: SELECT to_number(to_char(cancellation_date,'YYYY'))
1322: INTO l_cancel_date
1323: FROM fv_treasury_symbols
1324: WHERE treasury_symbol_id = g_treasury_symbol_id;
1325:
1326: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1327: v_log_text := 'Edit Check process start...' ;