APPS.FV_YE_CLOSE dependencies on FV_FUND_PARAMETERS

Line 49: vg_fund_value Fv_Fund_Parameters.fund_value%TYPE;

45: vg_acct_segnum NUMBER(4);
46: vg_bal_seg_val_opt_code gl_ledgers_public_v.bal_seg_value_option_code%TYPE;
47: vg_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
48: vg_trsymbol_id Fv_Treasury_Symbols.treasury_symbol_id%TYPE;
49: vg_fund_value Fv_Fund_Parameters.fund_value%TYPE;
50: vg_group_id Fv_Ye_Groups.group_id%TYPE;
51: vg_seq_id Fv_Ye_Group_Sequences.sequence_id%TYPE;
52: vg_seq Fv_Ye_Group_Sequences.SEQUENCE%TYPE;
53: vp_closing_method Fv_Ye_Groups.closing_method%TYPE ;

Line 61: treasury_closing_method fv_fund_parameters.close_requisitions%TYPE;

57: vg_to_acct Fv_Ye_Sequence_Accounts.to_account%TYPE;
58: vg_requisition Fv_Ye_Sequence_Accounts.requisition%TYPE;
59: vg_closing_method fv_ye_groups.closing_method%TYPE;
60: -- Bug 10399298
61: treasury_closing_method fv_fund_parameters.close_requisitions%TYPE;
62: vg_balance_read_flag Fv_Ye_Seq_Bal_Temp.balance_read_flag%TYPE;
63: vg_bal_seq_amt NUMBER;
64: vg_gl_bal_amt NUMBER;
65: vg_coy_dr NUMBER;

Line 1243: FROM Fv_Fund_Parameters

1239: PROCEDURE Get_Fund_Value IS
1240:
1241: CURSOR get_fund_cur IS
1242: SELECT fund_value
1243: FROM Fv_Fund_Parameters
1244: WHERE treasury_symbol_id = vg_trsymbol_id
1245: AND set_of_books_id = vg_sob_id;
1246:
1247: vl_rec_found_flag VARCHAR2(1) ;

Line 1351: FROM Fv_Treasury_Symbols fts, Fv_Fund_Parameters ffp

1347: CURSOR acctflag_cur IS
1348: SELECT fts.expiration_date,
1349: fts.cancellation_date,
1350: fts.time_frame
1351: FROM Fv_Treasury_Symbols fts, Fv_Fund_Parameters ffp
1352: WHERE fts.treasury_symbol_id = vg_trsymbol_id
1353: AND fts.treasury_symbol_id = ffp.treasury_symbol_id
1354: AND ffp.fund_value = vg_fund_value
1355: AND fts.treasury_symbol_id = ffp.treasury_symbol_id

Line 1531: -- Bug 10399298: Pick close_requisitions from fv_fund_parameters instead of fv_treasury_symbols

1527: /*SELECT close_requisitions into treasury_closing_method
1528: FROM fv_treasury_symbols
1529: WHERE treasury_symbol = vg_trsymbol and set_of_books_id = vg_sob_id;*/
1530:
1531: -- Bug 10399298: Pick close_requisitions from fv_fund_parameters instead of fv_treasury_symbols
1532: SELECT fund.close_requisitions into treasury_closing_method
1533: FROM fv_treasury_symbols tas, fv_fund_parameters fund
1534: WHERE tas.treasury_symbol = vg_trsymbol and tas.set_of_books_id = vg_sob_id
1535: AND fund.treasury_symbol_id = tas.treasury_symbol_id

Line 1533: FROM fv_treasury_symbols tas, fv_fund_parameters fund

1529: WHERE treasury_symbol = vg_trsymbol and set_of_books_id = vg_sob_id;*/
1530:
1531: -- Bug 10399298: Pick close_requisitions from fv_fund_parameters instead of fv_treasury_symbols
1532: SELECT fund.close_requisitions into treasury_closing_method
1533: FROM fv_treasury_symbols tas, fv_fund_parameters fund
1534: WHERE tas.treasury_symbol = vg_trsymbol and tas.set_of_books_id = vg_sob_id
1535: AND fund.treasury_symbol_id = tas.treasury_symbol_id
1536: AND fund.fund_value = vg_fund_value;
1537:

Line 2853: FROM fv_fund_parameters ffp, fv_treasury_symbols fts

2849: PROCEDURE Update_Closing_Status IS
2850:
2851: CURSOR get_closereq_cur IS
2852: SELECT ffp.close_requisitions
2853: FROM fv_fund_parameters ffp, fv_treasury_symbols fts
2854: WHERE fts.treasury_symbol = vg_trsymbol
2855: AND ffp.fund_value = vg_fund_value
2856: AND ffp.treasury_symbol_id = fts.treasury_symbol_id
2857: AND ffp.set_of_books_id = vg_sob_id

Line 2866: vl_close_req Fv_Fund_Parameters.close_requisitions%TYPE;

2862: vl_dist_retcur t_refcur;
2863: vl_dist_select VARCHAR2(2000);
2864:
2865: vl_rec_found_flag VARCHAR2(1) ;
2866: vl_close_req Fv_Fund_Parameters.close_requisitions%TYPE;
2867: vl_distr_id Po_Req_Distributions_All.distribution_id%TYPE;
2868: vl_line_id Po_Req_Distributions_All.requisition_line_id%TYPE;
2869: vl_req_num Po_Requisition_Headers_All.segment1%TYPE;
2870: vl_prev_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;

Line 4148: TYPE v_fund_val_blk IS TABLE OF fv_fund_parameters.fund_value%TYPE

4144: vp_tsymbol_id VARCHAR ,
4145: vp_sob_id NUMBER ,
4146: vp_end_date DATE )
4147: IS
4148: TYPE v_fund_val_blk IS TABLE OF fv_fund_parameters.fund_value%TYPE
4149: index by binary_integer;
4150:
4151: V_fund_blk_tbl v_fund_val_blk;
4152: l_select_stmt varchar2(2500);

Line 4186: FROM fv_fund_parameters ffp,

4182: ' END DATE= '||VP_END_DATE);
4183: END IF;
4184:
4185: L_select_stmt := ' SELECT ffp.fund_value
4186: FROM fv_fund_parameters ffp,
4187: Fv_Ye_Groups fyg ,
4188: fv_treasury_symbols fts
4189: WHERE fyg.fund_group_code = fts.fund_group_code
4190: AND fts.time_frame = fyg.fund_time_frame