eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_XTRCCYGL_XMLP_PKG dependencies on XTR_ROLLOVER_TRANSACTIONS

Line 397: XTR_ROLLOVER_TRANSACTIONS

393: CURSOR C_FIRST_TRANS IS
394: SELECT
395: SUM(INITIAL_FAIR_VALUE)
396: FROM
397: XTR_ROLLOVER_TRANSACTIONS
398: WHERE DEAL_NUMBER = REF_NUMBER_p;
399: CURSOR C_IRS IS
400: SELECT
401: SUM(INITIAL_FAIR_VALUE)

Line 452: XTR_ROLLOVER_TRANSACTIONS

448: AND TRANSACTION_NO in (
449: SELECT
450: TRANSACTION_NUMBER
451: FROM
452: XTR_ROLLOVER_TRANSACTIONS
453: WHERE DEAL_NUMBER = TO_NUMBER(REF_NUMBER_p)
454: AND START_DATE <= PERIOD_END_p
455: AND ( CROSS_REF_TO_TRANS is null
456: OR CROSS_REF_TO_TRANS not in (

Line 570: XTR_ROLLOVER_TRANSACTIONS

566: CURSOR C_NI_INIT_RATE IS
567: SELECT
568: AVG(CURRENCY_EXCHANGE_RATE)
569: FROM
570: XTR_ROLLOVER_TRANSACTIONS
571: WHERE DEAL_NUMBER = REF_NUMBER_p;
572: L_BEGIN_RATE NUMBER;
573: BEGIN
574: IF P_REALIZED_FLAG_T = 'Y' AND DEAL_TYPE not in ('CA','IG','ONC','FX') THEN