APPS.XTR_XTRCCYGL_XMLP_PKG dependencies on XTR_BATCHES

Line 128: XTR_BATCHES B,

124: ,'YYYY/MM/DD HH24:MI:SS')
125: INTO
126: P_DATE_FROM_T
127: FROM
128: XTR_BATCHES B,
129: XTR_BATCH_EVENTS E
130: WHERE B.BATCH_ID = E.BATCH_ID
131: AND E.EVENT_CODE = 'REVAL'
132: AND B.BATCH_ID >= P_BATCH_ID_FROM;

Line 143: XTR_BATCHES B,

139: ,'YYYY/MM/DD HH24:MI:SS')
140: INTO
141: P_DATE_TO_T
142: FROM
143: XTR_BATCHES B,
144: XTR_BATCH_EVENTS E
145: WHERE B.BATCH_ID = E.BATCH_ID
146: AND E.EVENT_CODE = 'REVAL'
147: AND B.BATCH_ID <= P_BATCH_ID_TO;

Line 378: XTR_BATCHES B

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
382: AND A.REF_NUMBER = REF_NUMBER_P

Line 545: XTR_BATCHES B

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
549: AND A.REF_NUMBER = REF_NUMBER_p

Line 645: XTR_BATCHES B

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
649: AND A.REF_NUMBER = REF_NUMBER_p