APPS.XTR_XTRCCYGL_XMLP_PKG dependencies on XTR_DEALS

Line 391: XTR_DEALS

387: CURSOR C_UNREAL_FIRST IS
388: SELECT
389: INITIAL_FAIR_VALUE
390: FROM
391: XTR_DEALS
392: WHERE DEAL_NO = REF_NUMBER_p;
393: CURSOR C_FIRST_TRANS IS
394: SELECT
395: SUM(INITIAL_FAIR_VALUE)

Line 403: XTR_DEALS

399: CURSOR C_IRS IS
400: SELECT
401: SUM(INITIAL_FAIR_VALUE)
402: FROM
403: XTR_DEALS
404: WHERE INT_SWAP_REF = REF_NUMBER_p;
405: CURSOR C_CA_FV IS
406: SELECT
407: FAIR_VALUE

Line 498: XTR_DEALS

494: INITIAL_FAIR_VALUE
495: INTO
496: L_FAIR_VALUE
497: FROM
498: XTR_DEALS
499: WHERE DEAL_NO = REF_NUMBER_p;
500: END IF;
501: IF L_FAIR_VALUE IS NULL AND DEAL_TYPE in ('NI') THEN
502: OPEN C_FIRST_TRANS;

Line 558: XTR_DEALS

554: CURSOR C_INIT_RATE IS
555: SELECT
556: EXCHANGE_RATE_ONE
557: FROM
558: XTR_DEALS
559: WHERE DEAL_NO = REF_NUMBER_p;
560: CURSOR C_IRS_RATE IS
561: SELECT
562: AVG(EXCHANGE_RATE_ONE)

Line 564: XTR_DEALS

560: CURSOR C_IRS_RATE IS
561: SELECT
562: AVG(EXCHANGE_RATE_ONE)
563: FROM
564: XTR_DEALS
565: WHERE INT_SWAP_REF = REF_NUMBER_p;
566: CURSOR C_NI_INIT_RATE IS
567: SELECT
568: AVG(CURRENCY_EXCHANGE_RATE)

Line 658: XTR_DEALS

654: CURSOR C_INIT_RATE IS
655: SELECT
656: EXCHANGE_RATE_ONE
657: FROM
658: XTR_DEALS
659: WHERE DEAL_NO = REF_NUMBER_p;
660: L_END_RATE NUMBER;
661:
662: BEGIN