APPS.XTR_XTRCCYGL_XMLP_PKG dependencies on XTR_REVALUATION_DETAILS

Line 377: XTR_REVALUATION_DETAILS_SUM_V A,

373: CURSOR C_UNREAL IS
374: SELECT
375: A.FAIR_VALUE
376: FROM
377: XTR_REVALUATION_DETAILS_SUM_V A,
378: XTR_BATCHES B
379: WHERE A.COMPANY_CODE = COMPANY_p
380: AND A.COMPANY_CODE = B.COMPANY_CODE
381: AND A.BATCH_ID = B.BATCH_ID

Line 409: XTR_REVALUATION_DETAILS

405: CURSOR C_CA_FV IS
406: SELECT
407: FAIR_VALUE
408: FROM
409: XTR_REVALUATION_DETAILS
410: WHERE ACCOUNT_NO = REF_NUMBER_P
411: AND DEAL_TYPE = 'CA'
412: AND BATCH_ID = BATCH_ID_P
413: AND EFFECTIVE_DATE = (

Line 417: XTR_REVALUATION_DETAILS

413: AND EFFECTIVE_DATE = (
414: SELECT
415: MAX(EFFECTIVE_DATE)
416: FROM
417: XTR_REVALUATION_DETAILS
418: WHERE ACCOUNT_NO = REF_NUMBER_p
419: AND DEAL_TYPE = 'CA'
420: AND BATCH_ID = BATCH_ID_p );
421: CURSOR C_IG_FV IS

Line 425: XTR_REVALUATION_DETAILS

421: CURSOR C_IG_FV IS
422: SELECT
423: FAIR_VALUE
424: FROM
425: XTR_REVALUATION_DETAILS
426: WHERE DEAL_NO = TO_NUMBER(REF_NUMBER_p)
427: AND DEAL_TYPE = 'IG'
428: AND BATCH_ID = BATCH_ID_p
429: AND EFFECTIVE_DATE = (

Line 433: XTR_REVALUATION_DETAILS

429: AND EFFECTIVE_DATE = (
430: SELECT
431: MAX(EFFECTIVE_DATE)
432: FROM
433: XTR_REVALUATION_DETAILS
434: WHERE DEAL_NO = REF_NUMBER_p
435: AND DEAL_TYPE = 'IG'
436: AND BATCH_ID = BATCH_ID_p );
437: CURSOR C_ONC_FV IS

Line 441: XTR_REVALUATION_DETAILS

437: CURSOR C_ONC_FV IS
438: SELECT
439: SUM(FACE_VALUE)
440: FROM
441: XTR_REVALUATION_DETAILS
442: WHERE DEAL_NO = TO_NUMBER(REF_NUMBER_p)
443: AND DEAL_TYPE = 'ONC'
444: AND BATCH_ID = BATCH_ID_p
445: AND NVL(REALIZED_FLAG

Line 460: XTR_REVALUATION_DETAILS

456: OR CROSS_REF_TO_TRANS not in (
457: SELECT
458: TRANSACTION_NO
459: FROM
460: XTR_REVALUATION_DETAILS
461: WHERE DEAL_NO = TO_NUMBER(REF_NUMBER_p)
462: AND BATCH_ID = BATCH_ID_p ) ) ) )
463: OR ( COMPLETE_FLAG = 'N'
464: AND TRANSACTION_NO = 1 ) );

Line 544: XTR_REVALUATION_DETAILS_SUM_V A,

540: SELECT
541: ROUND(A.EXCHANGE_RATE_ONE
542: ,4)
543: FROM
544: XTR_REVALUATION_DETAILS_SUM_V A,
545: XTR_BATCHES B
546: WHERE A.COMPANY_CODE = COMPANY
547: AND A.COMPANY_CODE = B.COMPANY_CODE
548: AND A.BATCH_ID = B.BATCH_ID

Line 644: XTR_REVALUATION_DETAILS_SUM_V A,

640: CURSOR C_END_RATE IS
641: SELECT
642: A.EXCHANGE_RATE_ONE
643: FROM
644: XTR_REVALUATION_DETAILS_SUM_V A,
645: XTR_BATCHES B
646: WHERE A.COMPANY_CODE = COMPANY_P
647: AND A.COMPANY_CODE = B.COMPANY_CODE
648: AND A.BATCH_ID = B.BATCH_ID