APPS.XTR_XTRREVGL_XMLP_PKG dependencies on XTR_BATCHES

Line 13: XTR_BATCHES B

9: SELECT
10: SUM(A.FAIR_VALUE)
11: FROM
12: XTR_REVALUATION_DETAILS_SUM_V A,
13: XTR_BATCHES B
14: WHERE A.COMPANY_CODE = COMPANY
15: AND A.COMPANY_CODE = B.COMPANY_CODE
16: AND A.BATCH_ID = B.BATCH_ID
17: AND A.REF_NUMBER = BEGIN_FVFORMULA.REF_NUMBER

Line 66: XTR_BATCHES B

62: SELECT
63: SUM(A.FAIR_VALUE)
64: FROM
65: XTR_REVALUATION_DETAILS_SUM_V A,
66: XTR_BATCHES B
67: WHERE A.COMPANY_CODE = COMPANY
68: AND A.COMPANY_CODE = B.COMPANY_CODE
69: AND A.BATCH_ID = B.BATCH_ID
70: AND A.REF_NUMBER = REF_NUMBER_1

Line 200: XTR_BATCHES B,

196: TO_CHAR(MIN(PERIOD_START)
197: ,'YYYY/MM/DD HH24:MI:SS')
198: INTO P_DATE_FROM
199: FROM
200: XTR_BATCHES B,
201: XTR_BATCH_EVENTS E
202: WHERE B.BATCH_ID = E.BATCH_ID
203: AND E.EVENT_CODE = 'REVAL'
204: AND B.BATCH_ID >= P_BATCH_ID_FROM;

Line 214: XTR_BATCHES B,

210: TO_CHAR(MAX(PERIOD_END)
211: ,'YYYY/MM/DD HH24:MI:SS')
212: INTO P_DATE_TO
213: FROM
214: XTR_BATCHES B,
215: XTR_BATCH_EVENTS E
216: WHERE B.BATCH_ID = E.BATCH_ID
217: AND E.EVENT_CODE = 'REVAL'
218: AND B.BATCH_ID <= P_BATCH_ID_TO;