APPS.FV_FACTS_TRANSACTIONS dependencies on FV_FUND_PARAMETERS

Line 112: v_tbal_fund_value fv_fund_parameters.fund_value%TYPE ;

108: v_record_category fv_facts_temp.fct_int_record_category%TYPE ;
109: v_sgl_acct_num fv_facts_ussgl_accounts.ussgl_account%TYPE ;
110: v_amount NUMBER ;
111: v_year_budget_auth VARCHAR2(3);
112: v_tbal_fund_value fv_fund_parameters.fund_value%TYPE ;
113: v_acct_num fv_Facts_attributes.facts_acct_number%TYPE ;
114: v_tbal_indicator fv_facts_temp.tbal_indicator%TYPE ;
115: v_period_activity NUMBER;
116: v_edit_check_code NUMBER ;

Line 255: vl_fund fv_fund_parameters.fund_value%TYPE;

251: vl_prc_map_count NUMBER := 0;
252: vl_prc_no_code_count NUMBER := 0;
253: vl_catb_rc_map_status VARCHAR2(15);
254: vl_prn_rc_map_status VARCHAR2(15);
255: vl_fund fv_fund_parameters.fund_value%TYPE;
256:
257: TYPE g_request_ids IS RECORD (request_id NUMBER) ;
258:
259: TYPE g_request_ids_type IS TABLE OF g_request_ids

Line 1287: FV_FUND_PARAMETERS FFP,

1283: ', GLCC.' || v_fyr_segment_name ||
1284: v_cohort_select ||
1285: ' FROM GL_BALANCES GLB,
1286: GL_CODE_COMBINATIONS GLCC,
1287: FV_FUND_PARAMETERS FFP,
1288: FV_TREASURY_SYMBOLS FTS
1289: WHERE FTS.TREASURY_SYMBOL = :treasury_symbol
1290: AND GLB.code_combination_id = GLCC.code_combination_id
1291: AND glb.actual_flag = :actual_flag

Line 1324: FV_FUND_PARAMETERS FFP,

1320: ,SUM(decode(glb.period_name,:e_period_name,glb.begin_balance_dr - glb.begin_balance_cr +
1321: glb.period_net_dr - glb.period_net_cr,0)) end_amount
1322: FROM GL_BALANCES GLB,
1323: GL_CODE_COMBINATIONS GLCC,
1324: FV_FUND_PARAMETERS FFP,
1325: FV_TREASURY_SYMBOLS FTS
1326: WHERE FTS.TREASURY_SYMBOL = :treasury_symbol
1327: AND FTS.SET_OF_BOOKS_ID = :set_of_books_id
1328: AND FFP.TREASURY_SYMBOL_ID = FTS.TREASURY_SYMBOL_ID

Line 3864: fv_fund_parameters ffp

3860: va_def_indef_val,
3861: vl_fund_category,
3862: va_reimburseable_val
3863: FROM fv_treasury_symbols fts,
3864: fv_fund_parameters ffp
3865: WHERE ffp.treasury_symbol_id = fts.treasury_symbol_id
3866: AND ffp.fund_value = fund_val
3867: AND fts.treasury_symbol = vp_treasury_symbol
3868: AND fts.set_of_books_id = vp_set_of_books_id

Line 4001: from fv_fund_parameters

3997: -- by ks for bug 6409180
3998: BEGIN
3999: SELECT RPAD(substr(bea_category,1,5), 5)
4000: INTO va_bea_category_val
4001: from fv_fund_parameters
4002: where fund_value = fund_val
4003: AND set_of_books_id = vp_set_of_books_id;
4004:
4005: /*

Line 4102: FROM fv_fund_parameters ffp,

4098: -- Report only those treasury symbols whose FACTS_REPORTABLE_INDICATOR is (I or II) or II
4099:
4100: SELECT RPAD(substr(ffp.borrowing_source_code,1,5), 5)
4101: INTO va_borrowing_source_val
4102: FROM fv_fund_parameters ffp,
4103: fv_treasury_symbols fts
4104: WHERE fts.treasury_symbol_id = ffp.treasury_symbol_id
4105: AND fts.treasury_symbol = vp_treasury_symbol
4106: AND fts.set_of_books_id = vp_set_of_books_id

Line 4909: FROM fv_fund_parameters ffp

4905: CURSOR fund_cur(cv_ts_id IN NUMBER,
4906: cv_sob_id IN NUMBER) IS
4907: SELECT fund_value,
4908: DECODE(fund_category,'S','A','T','B',fund_category) fund_category
4909: FROM fv_fund_parameters ffp
4910: WHERE ffp.treasury_symbol_id = cv_ts_id
4911: AND ffp.set_of_books_id = cv_sob_id
4912: AND ffp.fund_category IN ('A', 'B', 'S', 'T');
4913:

Line 4915: vl_fund_value fv_fund_parameters.fund_value%TYPE;

4911: AND ffp.set_of_books_id = cv_sob_id
4912: AND ffp.fund_category IN ('A', 'B', 'S', 'T');
4913:
4914: vl_ts_id NUMBER;
4915: vl_fund_value fv_fund_parameters.fund_value%TYPE;
4916: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;
4917: vl_prc_header_id NUMBER;
4918: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
4919: vl_code_type fv_facts_prc_hdr.code_type%TYPE;