APPS.XTR_EXP_TRANSFERS_PKG dependencies on XTR_MASTER_CURRENCIES_V

Line 393: from xtr_master_currencies_v

389: ------------------------------------------------------------------------*/
390: function VALID_CURRENCY(p_curr IN VARCHAR2) return boolean IS
391: CURSOR currency IS
392: select COUNT(*)
393: from xtr_master_currencies_v
394: where currency = p_curr
395: and NVL(authorised,'N')='Y';
396:
397: v_count NUMBER;

Line 651: -- from XTR_MASTER_CURRENCIES_V

647: -- Example from Exposure Transactions FORMS
648: -- cursor HCE is
649: -- select nvl(round(nvl(:ET.AMOUNT,:ET.ESTIMATE_AMOUNT)/p_hce_rate,
650: -- rounding_factor),0)
651: -- from XTR_MASTER_CURRENCIES_V
652: -- where CURRENCY = :ET.CURRENCY;
653: --
654: v_hce_amount NUMBER;
655:

Line 691: from XTR_master_currencies_V

687: where party_code = p_company_code;
688:
689: cursor get_rate_hce is
690: select round(hce_rate,5)
691: from XTR_master_currencies_V
692: where currency = p_curr;
693:
694: v_home_curr VARCHAR2(20);
695: v_fx_rate NUMBER;