APPS.FV_FACTS_TRX_REGISTER dependencies on FV_FACTS_FEDERAL_ACCOUNTS

Line 18: g_cohort_seg_name FV_FACTS_FEDERAL_ACCOUNTS.cohort_segment_name%TYPE;

14: g_period_num_low Gl_Balances.period_num%TYPE;
15: g_period_num_high Gl_Balances.period_num%TYPE;
16: g_from_period_name Gl_Period_Statuses.period_name%TYPE;
17: g_to_period_name Gl_Period_Statuses.period_name%TYPE;
18: g_cohort_seg_name FV_FACTS_FEDERAL_ACCOUNTS.cohort_segment_name%TYPE;
19: g_bal_segment_name VARCHAR2(25);
20: g_acct_segment_name VARCHAR2(25);
21: g_reimb_agree_seg_name VARCHAR2(25);
22: g_acc_value_set_id NUMBER;

Line 849: l_financing_acct fv_facts_federal_accounts.financing_account%TYPE ;

845: l_period_year NUMBER(15);
846: l_cohort_year VARCHAR2(10);
847: l_disbursements_flag VARCHAR2(1);
848: l_time_frame fv_treasury_symbols.time_frame%TYPE ;
849: l_financing_acct fv_facts_federal_accounts.financing_account%TYPE ;
850: l_cohort_select VARCHAR2(100) ;
851: l_cohort VARCHAR2(2) ;
852: l_cohort_num_year NUMBER;
853: l_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%TYPE;

Line 2944: FROM FV_FACTS_FEDERAL_ACCOUNTS FFFA,

2940:
2941: BEGIN
2942: SELECT FTS.Time_Frame, fts.financing_account
2943: INTO l_time_frame, l_financing_acct
2944: FROM FV_FACTS_FEDERAL_ACCOUNTS FFFA,
2945: FV_TREASURY_SYMBOLS FTS
2946: WHERE FFFA.Federal_acct_symbol_id = FTS.Federal_acct_symbol_id
2947: AND FTS.treasury_symbol_id = g_treasury_symbol_id
2948: AND FTS.set_of_books_id = g_set_of_books_id

Line 4847: fv_facts_federal_accounts fffa,

4843: AND set_of_books_id = g_set_of_books_id;
4844:
4845: /* Commented for CGAC
4846: FROM fv_facts_budget_accounts ffba,
4847: fv_facts_federal_accounts fffa,
4848: fv_treasury_symbols fts ,
4849: fv_facts_bud_fed_accts ffbfa
4850: WHERE fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
4851: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id

Line 4892: fv_facts_federal_accounts fffa,

4888: BEGIN
4889: SELECT RPAD(SUBSTR(ffba.budget_function,1,3), 3)
4890: INTO g_budget_function_val
4891: FROM fv_facts_budget_accounts ffba,
4892: fv_facts_federal_accounts fffa,
4893: fv_treasury_symbols fts ,
4894: fv_facts_bud_fed_accts ffbfa
4895: WHERE fts.federal_acct_symbol_id = fffa.federal_acct_symbol_id
4896: AND fffa.federal_acct_symbol_id = ffbfa.federal_acct_symbol_id

Line 5112: FROM FV_FACTS_FEDERAL_ACCOUNTS FFFA,

5108: SELECT fts.financing_account,
5109: fpfs.cohort_segment_name
5110: INTO l_financing_acct,
5111: g_cohort_seg_name
5112: FROM FV_FACTS_FEDERAL_ACCOUNTS FFFA,
5113: FV_TREASURY_SYMBOLS FTS,
5114: FV_PYA_FISCALYEAR_SEGMENT fpfs
5115: WHERE FFFA.Federal_acct_symbol_id = FTS.Federal_acct_symbol_id
5116: AND FTS.treasury_symbol_id = g_treasury_symbol_id