APPS.FV_FACTS_EDIT_CHECK dependencies on FV_TREASURY_SYMBOLS

Line 630: -- fv_treasury_symbols

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
634: WHERE treasury_symbol_id = g_treasury_symbol_id;

Line 969: FROM fv_treasury_symbols

965: --Fetch the authorization code for the treasury symbol
966:
967: /*SELECT NVL(preclosing_subclass_amt, 0)
968: INTO l_subclass_amt
969: FROM fv_treasury_symbols
970: WHERE treasury_symbol_id = g_treasury_symbol_id
971: AND set_of_books_id = l_set_of_books_id;*/
972:
973: SELECT NVL(PRECLOSING_SUBCLASS43_AMT, 0)

Line 1313: from fv_treasury_symbols

1309: --Fetch 224 Outlays
1310: select decode(p_facts_run_quarter,1,sf224_qtr1_outlay,
1311: 2,sf224_qtr2_outlay,3,sf224_qtr3_outlay,sf224_qtr4_outlay)
1312: into l_224_outlays
1313: from fv_treasury_symbols
1314: where treasury_symbol_id = g_treasury_symbol_id;
1315:
1316: IF (l_224_outlays is NULL) THEN
1317:

Line 1481: FROM fv_treasury_symbols

1477: l_auth_type :=NULL;
1478: -- check if treasury symbol has expired
1479: SELECT expiration_date
1480: INTO exp_date
1481: FROM fv_treasury_symbols
1482: WHERE treasury_symbol_id = g_treasury_symbol_id;
1483:
1484: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1485: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Expiration date for treasury id '||g_treasury_symbol_id||' is '||exp_date);

Line 2056: FROM fv_facts_temp facts, fv_facts_federal_accounts fffa, fv_treasury_symbols fts

2052:
2053: CURSOR check_18 IS
2054: SELECT nvl(amount,0) amt , sgl_acct_number, transaction_partner,
2055: treasury_dept_code, treasury_acct_code, decode(fffa.non_fed_exc_flag,'Y', 'Allowed','Not Allowed')non_fed_exc_flag_desc
2056: FROM fv_facts_temp facts, fv_facts_federal_accounts fffa, fv_treasury_symbols fts
2057: WHERE facts.treasury_symbol_id = g_treasury_symbol_id
2058: AND facts.treasury_symbol_id = fts.treasury_symbol_id
2059: AND fts.federal_Acct_symbol_id = fffa.federal_Acct_symbol_id
2060: AND ((transaction_partner = 'E'

Line 2677: l_subclass_prefix_code fv_treasury_symbols.sub_level_prefix_code%TYPE;

2673: l_module_name VARCHAR2(200) := g_module_name || 'perform_edit_checks';
2674: -- Added to fix 1974485
2675: l_cancel_date NUMBER(4);
2676: no_rec NUMBER;
2677: l_subclass_prefix_code fv_treasury_symbols.sub_level_prefix_code%TYPE;
2678: hard_edit_failed_flg VARCHAR2(1) DEFAULT 'N';
2679:
2680: begin
2681:

Line 2691: FROM fv_treasury_symbols

2687: g_period_year :=p_rep_fiscal_yr;
2688:
2689: SELECT to_number(to_char(cancellation_date,'YYYY')),sub_level_prefix_code
2690: INTO l_cancel_date, l_subclass_prefix_code
2691: FROM fv_treasury_symbols
2692: WHERE treasury_symbol_id = g_treasury_symbol_id;
2693:
2694: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2695: v_log_text := 'Edit Check process start...' ;