eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_CGAC_CRT_TAS dependencies on FV_FACTS_FEDERAL_ACCOUNTS

Line 74: SELECT a.* FROM fv_treasury_symbols a, fv_facts_federal_accounts b

70: l_module_name VARCHAR2(200) ;
71:
72: -- CURSOR DEFINITIONS
73: CURSOR c_treasury_symbol IS
74: SELECT a.* FROM fv_treasury_symbols a, fv_facts_federal_accounts b
75: WHERE b.treasury_dept_code = nvl(p_agency_identifier,b.treasury_dept_code)
76: AND (a.time_frame = 'A' or a.time_frame = 'M')
77: AND a.end_year_avail = p_copy_fiscal_year
78: --AND a.auto_create = 'Y'

Line 125: l_treasury_acct_code FV_FACTS_FEDERAL_ACCOUNTS.treasury_acct_code%TYPE;

121: l_treasury_symbol_id FV_TREASURY_SYMBOLS.treasury_symbol_id%TYPE;
122: l_fund_value FV_FUND_PARAMETERS.FUND_VALUE%TYPE;
123: l_bud_distribution_id FV_BUDGET_DISTRIBUTION_HDR.distribution_id%TYPE;
124: l_bud_distribution_dtl_id FV_BUDGET_DISTRIBUTION_DTL.distribution_dtl_id%TYPE;
125: l_treasury_acct_code FV_FACTS_FEDERAL_ACCOUNTS.treasury_acct_code%TYPE;
126: l_treasury_dept_code FV_FACTS_FEDERAL_ACCOUNTS.treasury_dept_code%TYPE;
127:
128: v_bal_seg_name VARCHAR2(20);
129: v_acc_seg_name VARCHAR2(20);

Line 126: l_treasury_dept_code FV_FACTS_FEDERAL_ACCOUNTS.treasury_dept_code%TYPE;

122: l_fund_value FV_FUND_PARAMETERS.FUND_VALUE%TYPE;
123: l_bud_distribution_id FV_BUDGET_DISTRIBUTION_HDR.distribution_id%TYPE;
124: l_bud_distribution_dtl_id FV_BUDGET_DISTRIBUTION_DTL.distribution_dtl_id%TYPE;
125: l_treasury_acct_code FV_FACTS_FEDERAL_ACCOUNTS.treasury_acct_code%TYPE;
126: l_treasury_dept_code FV_FACTS_FEDERAL_ACCOUNTS.treasury_dept_code%TYPE;
127:
128: v_bal_seg_name VARCHAR2(20);
129: v_acc_seg_name VARCHAR2(20);
130: v_fyr_segment_name VARCHAR2(20);

Line 250: FROM fv_facts_federal_accounts b, fv_treasury_symbols a

246: END IF;
247:
248: BEGIN
249: SELECT treasury_dept_code, treasury_acct_code into l_treasury_dept_code, l_treasury_acct_code
250: FROM fv_facts_federal_accounts b, fv_treasury_symbols a
251: WHERE a.treasury_symbol_id = l_treasury_symbol_id
252: AND a.federal_acct_symbol_id = b.federal_acct_symbol_id
253: AND a.set_of_books_id = p_ledger_id;
254: EXCEPTION