APPS.XTR_EXP_SUMM_P dependencies on XTR_SPOT_RATES

Line 859: from XTR_spot_rates

855: FROM XTR_CURRENCY_CROSS_RATES
856: WHERE CURRENCY_FIRST=p_base_ccy
857: and CURRENCY_SECOND=p_contra_ccy
858: and rate_date in(select max(rate_date)
859: from XTR_spot_rates
860: where CURRENCY_FIRST=p_base_ccy
861: and CURRENCY_SECOND=p_contra_ccy
862: and to_char(rate_date,'DD-MM-YYYY')=to_char(p_date,'DD-MM-YYYY'));
863: --

Line 866: FROM XTR_spot_rates

862: and to_char(rate_date,'DD-MM-YYYY')=to_char(p_date,'DD-MM-YYYY'));
863: --
864: cursor get_rate(l_ccy varchar2) is
865: SELECT USD_BASE_CURR_BID_RATE
866: FROM XTR_spot_rates
867: WHERE currency = l_ccy
868: and rate_date in(select max(rate_date)
869: from XTR_spot_rates
870: where currency=l_ccy

Line 869: from XTR_spot_rates

865: SELECT USD_BASE_CURR_BID_RATE
866: FROM XTR_spot_rates
867: WHERE currency = l_ccy
868: and rate_date in(select max(rate_date)
869: from XTR_spot_rates
870: where currency=l_ccy
871: and to_char(rate_date,'DD-MM-YYYY')=to_char(p_date,'DD-MM-YYYY'));
872: l_base_rate number;
873: l_contra_rate number;

Line 913: from XTR_spot_rates

909: p_date DATE) RETURN NUMBER IS
910:
911: cursor get_rate is
912: select HCE_RATE
913: from XTR_spot_rates
914: where currency=p_base_ccy
915: and rate_date in(select max(rate_date)
916: from XTR_spot_rates
917: where currency = p_base_ccy

Line 916: from XTR_spot_rates

912: select HCE_RATE
913: from XTR_spot_rates
914: where currency=p_base_ccy
915: and rate_date in(select max(rate_date)
916: from XTR_spot_rates
917: where currency = p_base_ccy
918: and to_char(rate_date,'DD-MM-YYYY')=to_char(p_date,'DD-MM-YYYY'));
919: --
920: l_hce_rate number;