APPS.XTR_COF_P dependencies on XTR_AVG_RATES_RESULTS

Line 2944: * and insert that summary information in the "temporary" XTR_AVG_RATES_RESULTS

2940:
2941: /******************************************************************************/
2942: /* Upload_Avg_Rates_Results can be called from a form via Find Window or
2943: * from a report with the necessary parameters to query the Cost of Funds table
2944: * and insert that summary information in the "temporary" XTR_AVG_RATES_RESULTS
2945: * table. This table is actually always in the database but data that is
2946: * inserted is never committed so the results can be seen during a session
2947: * and erased once the session is over. This way no maintenance is necessary
2948: * for this table.

Line 3388: INSERT INTO xtr_avg_rates_results(unique_id, p_i, period, date_from, date_to, company_code, deal_type,

3384: FETCH c_get_minmax_rate_fx INTO v_min_rate, v_max_rate;
3385: CLOSE c_get_minmax_rate_fx;
3386: END IF;
3387:
3388: INSERT INTO xtr_avg_rates_results(unique_id, p_i, period, date_from, date_to, company_code, deal_type,
3389: product_type, portfolio_code, cparty_code, currency, currency_combination, principal,
3390: interest, average_contract_rate, average_spot_rate, minimum_rate, maximum_rate, num_deals)
3391: VALUES(
3392: p_batch_id, v_p_i, v_period,