APPS.FV_FACTS_TRANSACTIONS dependencies on FV_FUND_PARAMETERS

Line 106: v_tbal_fund_value fv_fund_parameters.fund_value%TYPE ;

102: v_record_category fv_facts_temp.fct_int_record_category%TYPE ;
103: v_sgl_acct_num fv_facts_ussgl_accounts.ussgl_account%TYPE ;
104: v_amount NUMBER ;
105: v_year_budget_auth VARCHAR2(3);
106: v_tbal_fund_value fv_fund_parameters.fund_value%TYPE ;
107: v_acct_num fv_Facts_attributes.facts_acct_number%TYPE ;
108: v_tbal_indicator fv_facts_temp.tbal_indicator%TYPE ;
109: v_period_activity NUMBER;
110: v_edit_check_code NUMBER ;

Line 247: vl_fund fv_fund_parameters.fund_value%TYPE;

243: vl_prc_map_count NUMBER := 0;
244: vl_prc_no_code_count NUMBER := 0;
245: vl_catb_rc_map_status VARCHAR2(15);
246: vl_prn_rc_map_status VARCHAR2(15);
247: vl_fund fv_fund_parameters.fund_value%TYPE;
248:
249: TYPE g_request_ids IS RECORD (request_id NUMBER) ;
250:
251: TYPE g_request_ids_type IS TABLE OF g_request_ids

Line 1255: FV_FUND_PARAMETERS FFP,

1251: ', GLCC.' || v_fyr_segment_name ||
1252: v_cohort_select ||
1253: ' FROM GL_BALANCES GLB,
1254: GL_CODE_COMBINATIONS GLCC,
1255: FV_FUND_PARAMETERS FFP,
1256: FV_TREASURY_SYMBOLS FTS
1257: WHERE FTS.TREASURY_SYMBOL = :treasury_symbol
1258: AND GLB.code_combination_id = GLCC.code_combination_id
1259: AND glb.actual_flag = :actual_flag

Line 1292: FV_FUND_PARAMETERS FFP,

1288: ,SUM(decode(glb.period_name,:e_period_name,glb.begin_balance_dr - glb.begin_balance_cr +
1289: glb.period_net_dr - glb.period_net_cr,0)) end_amount
1290: FROM GL_BALANCES GLB,
1291: GL_CODE_COMBINATIONS GLCC,
1292: FV_FUND_PARAMETERS FFP,
1293: FV_TREASURY_SYMBOLS FTS
1294: WHERE FTS.TREASURY_SYMBOL = :treasury_symbol
1295: AND FTS.SET_OF_BOOKS_ID = :set_of_books_id
1296: AND FFP.TREASURY_SYMBOL_ID = FTS.TREASURY_SYMBOL_ID

Line 3794: fv_fund_parameters ffp

3790: INTO vl_resource_type,
3791: va_def_indef_val,
3792: vl_fund_category
3793: FROM fv_treasury_symbols fts,
3794: fv_fund_parameters ffp
3795: WHERE ffp.treasury_symbol_id = fts.treasury_symbol_id
3796: AND ffp.fund_value = fund_val
3797: AND fts.treasury_symbol = vp_treasury_symbol
3798: AND fts.set_of_books_id = vp_set_of_books_id

Line 3930: from fv_fund_parameters

3926: -- by ks for bug 6409180
3927: BEGIN
3928: SELECT RPAD(substr(bea_category,1,5), 5)
3929: INTO va_bea_category_val
3930: from fv_fund_parameters
3931: where fund_value = fund_val
3932: AND set_of_books_id = vp_set_of_books_id;
3933:
3934: /*

Line 4834: FROM fv_fund_parameters ffp

4830: CURSOR fund_cur(cv_ts_id IN NUMBER,
4831: cv_sob_id IN NUMBER) IS
4832: SELECT fund_value,
4833: DECODE(fund_category,'S','A','T','B',fund_category) fund_category
4834: FROM fv_fund_parameters ffp
4835: WHERE ffp.treasury_symbol_id = cv_ts_id
4836: AND ffp.set_of_books_id = cv_sob_id
4837: AND ffp.fund_category IN ('A', 'B', 'S', 'T');
4838:

Line 4840: vl_fund_value fv_fund_parameters.fund_value%TYPE;

4836: AND ffp.set_of_books_id = cv_sob_id
4837: AND ffp.fund_category IN ('A', 'B', 'S', 'T');
4838:
4839: vl_ts_id NUMBER;
4840: vl_fund_value fv_fund_parameters.fund_value%TYPE;
4841: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;
4842: vl_prc_header_id NUMBER;
4843: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
4844: vl_code_type fv_facts_prc_hdr.code_type%TYPE;