APPS.XTR_XTROHINS_XMLP_PKG dependencies on XTR_DEALS

Line 293: XTR_DEALS

289: ,1) SELL_AMOUNT,
290: FACE_VALUE_AMOUNT / NVL(P_UNIT
291: ,1) FACE_VALUE_AMOUNT
292: FROM
293: XTR_DEALS
294: WHERE DEAL_NO = DEAL_NO_1;
295: BEGIN
296: OPEN CCY;
297: FETCH CCY

Line 344: XTR_DEALS

340: CURRENCY,
341: CURRENCY_BUY,
342: CURRENCY_SELL
343: FROM
344: XTR_DEALS
345: WHERE DEAL_NO = DEAL_NO_1;
346: CURSOR CUR_IRS IS
347: SELECT
348: TEXT

Line 392: XTR_DEALS

388: CURRENCY,
389: CURRENCY_BUY,
390: CURRENCY_SELL
391: FROM
392: XTR_DEALS
393: WHERE DEAL_NO = DEAL_NO_1;
394: CURSOR IRS_CCY IS
395: SELECT
396: CURRENCY

Line 398: XTR_DEALS

394: CURSOR IRS_CCY IS
395: SELECT
396: CURRENCY
397: FROM
398: XTR_DEALS
399: WHERE INT_SWAP_REF = (
400: SELECT
401: INT_SWAP_REF
402: FROM

Line 403: XTR_DEALS

399: WHERE INT_SWAP_REF = (
400: SELECT
401: INT_SWAP_REF
402: FROM
403: XTR_DEALS
404: WHERE DEAL_NO = DEAL_NO_1 )
405: AND DEAL_SUBTYPE = 'INVEST'
406: AND DEAL_TYPE = 'IRS';
407: BEGIN

Line 465: XTR_DEALS

461: ,1) SELL_AMOUNT,
462: FACE_VALUE_AMOUNT / NVL(P_UNIT
463: ,1) FACE_VALUE_AMOUNT
464: FROM
465: XTR_DEALS
466: WHERE DEAL_NO = DEAL_NO_1;
467: CURSOR ALLOC IS
468: SELECT
469: SUM(CUR_PCT_ALLOCATION)