DBA Data[Home] [Help]

APPS.XTR_XTRCCYGL_XMLP_PKG dependencies on XTR_REVALUATION_DETAILS_SUM_V

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 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