APPS.FV_GTAS_TRX_REGISTER dependencies on FV_FACTS_FEDERAL_ACCOUNTS

Line 34: g_cohort_seg_name FV_FACTS_FEDERAL_ACCOUNTS.cohort_segment_name%TYPE;

30: g_period_num_low Gl_Balances.period_num%TYPE;
31: g_period_num_high Gl_Balances.period_num%TYPE;
32: g_from_period_name Gl_Period_Statuses.period_name%TYPE;
33: g_to_period_name Gl_Period_Statuses.period_name%TYPE;
34: g_cohort_seg_name FV_FACTS_FEDERAL_ACCOUNTS.cohort_segment_name%TYPE;
35: g_bal_segment_name VARCHAR2(25);
36: g_acct_segment_name VARCHAR2(25);
37: g_reimb_agree_seg_name VARCHAR2(25);
38: g_acc_value_set_id NUMBER;

Line 4813: FROM FV_FACTS_FEDERAL_ACCOUNTS FFFA,

4809: SELECT fts.financing_account,
4810: fpfs.cohort_segment_name
4811: INTO l_financing_acct,
4812: g_cohort_seg_name
4813: FROM FV_FACTS_FEDERAL_ACCOUNTS FFFA,
4814: FV_TREASURY_SYMBOLS FTS,
4815: FV_PYA_FISCALYEAR_SEGMENT fpfs
4816: WHERE FFFA.Federal_acct_symbol_id = FTS.Federal_acct_symbol_id
4817: AND FTS.treasury_symbol_id = g_treasury_symbol_id

Line 5451: l_non_fed_exc_flag fv_facts_federal_accounts.non_fed_exc_flag%TYPE;

5447: p_party_fed_nonfed_code IN VARCHAR2,
5448: p_fed_nonfed_code OUT NOCOPY VARCHAR2)
5449: IS
5450: l_module VARCHAR2(200) := g_module||'GET_FED_NONFED_CODE';
5451: l_non_fed_exc_flag fv_facts_federal_accounts.non_fed_exc_flag%TYPE;
5452: l_code_exists VARCHAR2(1);
5453: l_account_number fv_gtas_attributes.gtas_acct_number%TYPE;
5454: l_fednonfed_count NUMBER := 0;
5455: BEGIN

Line 5562: FROM fv_facts_federal_accounts ffa,

5558: --If nonfederal exception is checked and gtas attribute incldes E return E
5559: --else error
5560: SELECT NVL(ffa.non_fed_exc_flag,'N')
5561: INTO l_non_fed_exc_flag
5562: FROM fv_facts_federal_accounts ffa,
5563: fv_treasury_symbols fts,
5564: fv_fund_parameters ffp
5565: WHERE ffp.set_of_books_id = g_set_of_books_id
5566: AND ffp.fund_value = p_fund_value