APPS.FV_YE_CLOSE dependencies on FV_FUND_PARAMETERS

Line 46: vg_fund_value Fv_Fund_Parameters.fund_value%TYPE;

42: vg_acct_segnum NUMBER(4);
43: vg_bal_seg_val_opt_code gl_ledgers_public_v.bal_seg_value_option_code%TYPE;
44: vg_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
45: vg_trsymbol_id Fv_Treasury_Symbols.treasury_symbol_id%TYPE;
46: vg_fund_value Fv_Fund_Parameters.fund_value%TYPE;
47: vg_group_id Fv_Ye_Groups.group_id%TYPE;
48: vg_seq_id Fv_Ye_Group_Sequences.sequence_id%TYPE;
49: vg_seq Fv_Ye_Group_Sequences.SEQUENCE%TYPE;
50: vg_acct_flag Fv_Ye_Sequence_Accounts.account_flag%TYPE;

Line 1227: FROM Fv_Fund_Parameters

1223: PROCEDURE Get_Fund_Value IS
1224:
1225: CURSOR get_fund_cur IS
1226: SELECT fund_value
1227: FROM Fv_Fund_Parameters
1228: WHERE treasury_symbol_id = vg_trsymbol_id
1229: AND set_of_books_id = vg_sob_id;
1230:
1231: vl_rec_found_flag VARCHAR2(1) ;

Line 1335: FROM Fv_Treasury_Symbols fts, Fv_Fund_Parameters ffp

1331: CURSOR acctflag_cur IS
1332: SELECT fts.expiration_date,
1333: fts.cancellation_date,
1334: fts.time_frame
1335: FROM Fv_Treasury_Symbols fts, Fv_Fund_Parameters ffp
1336: WHERE fts.treasury_symbol_id = vg_trsymbol_id
1337: AND fts.treasury_symbol_id = ffp.treasury_symbol_id
1338: AND ffp.fund_value = vg_fund_value
1339: AND fts.treasury_symbol_id = ffp.treasury_symbol_id

Line 2804: FROM fv_fund_parameters ffp, fv_treasury_symbols fts

2800: PROCEDURE Update_Closing_Status IS
2801:
2802: CURSOR get_closereq_cur IS
2803: SELECT ffp.close_requisitions
2804: FROM fv_fund_parameters ffp, fv_treasury_symbols fts
2805: WHERE fts.treasury_symbol = vg_trsymbol
2806: AND ffp.fund_value = vg_fund_value
2807: AND ffp.treasury_symbol_id = fts.treasury_symbol_id
2808: AND ffp.set_of_books_id = vg_sob_id;

Line 2816: vl_close_req Fv_Fund_Parameters.close_requisitions%TYPE;

2812: vl_dist_retcur t_refcur;
2813: vl_dist_select VARCHAR2(2000);
2814:
2815: vl_rec_found_flag VARCHAR2(1) ;
2816: vl_close_req Fv_Fund_Parameters.close_requisitions%TYPE;
2817: vl_distr_id Po_Req_Distributions_All.distribution_id%TYPE;
2818: vl_line_id Po_Req_Distributions_All.requisition_line_id%TYPE;
2819: vl_req_num Po_Requisition_Headers_All.segment1%TYPE;
2820: vl_prev_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;

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

3940: vp_tsymbol_id VARCHAR ,
3941: vp_sob_id NUMBER ,
3942: vp_end_date DATE )
3943: IS
3944: TYPE v_fund_val_blk IS TABLE OF fv_fund_parameters.fund_value%TYPE
3945: index by binary_integer;
3946:
3947: V_fund_blk_tbl v_fund_val_blk;
3948: l_select_stmt varchar2(2500);

Line 3982: FROM fv_fund_parameters ffp,

3978: ' END DATE= '||VP_END_DATE);
3979: END IF;
3980:
3981: L_select_stmt := ' SELECT ffp.fund_value
3982: FROM fv_fund_parameters ffp,
3983: Fv_Ye_Groups fyg ,
3984: fv_treasury_symbols fts
3985: WHERE fyg.fund_group_code = fts.fund_group_code
3986: AND fts.time_frame = fyg.fund_time_frame