APPS.FV_SLA_PROCESSING_PKG dependencies on FV_FUND_PARAMETERS

Line 631: l_fund_value Fv_Fund_Parameters.fund_value%TYPE;

627: l_anticipated_acct VARCHAR2(30);
628: l_template_id NUMBER;
629: l_currency_code VARCHAR2(30);
630: l_ccid Gl_Code_Combinations.code_combination_id%TYPE;
631: l_fund_value Fv_Fund_Parameters.fund_value%TYPE;
632: l_amount NUMBER;
633: l_tot_amount NUMBER := 0;
634:
635: -- Variable declartions for Dynamic SQL

Line 1153: FROM FV_FUND_PARAMETERS

1149: l_procedure_name VARCHAR2(100) :='.GET_FUND_DETAILS';
1150:
1151: CURSOR c_get_fund_details IS
1152: SELECT fund_category, fund_expire_date
1153: FROM FV_FUND_PARAMETERS
1154: WHERE FUND_VALUE=P_fund_value;
1155:
1156: l_fund_details c_get_fund_details%ROWTYPE;
1157:

Line 1236: FROM FV_FUND_PARAMETERS

1232: l_procedure_name VARCHAR2(100) :='.GET_FUND_DETAILS';
1233:
1234: CURSOR c_get_fund_details IS
1235: SELECT fund_category, fund_expire_date
1236: FROM FV_FUND_PARAMETERS
1237: WHERE FUND_VALUE = p_fund_value
1238: AND set_of_books_id = p_ledger_id ;
1239:
1240: /* Get the fund time frame */

Line 1243: FROM fv_treasury_symbols ts, fv_fund_parameters fp

1239:
1240: /* Get the fund time frame */
1241: CURSOR c_get_fund_time_frame IS
1242: SELECT ts.time_frame
1243: FROM fv_treasury_symbols ts, fv_fund_parameters fp
1244: WHERE ts.treasury_symbol_id = fp.treasury_symbol_id
1245: AND fp.fund_value = p_fund_value
1246: AND ts.set_of_books_id = p_ledger_id;
1247:

Line 2954: FROM fv_fund_parameters

2950: CURSOR cur_ar_get_fund_catg (p_set_of_books_id NUMBER,
2951: p_fund_value VARCHAR2)
2952: IS
2953: SELECT fund_category
2954: FROM fv_fund_parameters
2955: WHERE set_of_books_id = p_set_of_books_id
2956: AND fund_value = p_fund_value;
2957:
2958: /* Get the AR Invoice Extract Details */