APPS.XTR_XTRIGSUM_XMLP_PKG dependencies on XTR_INTERGROUP_TRANSFERS

Line 246: from xtr_intergroup_transfers

242: L_DAY_COUNT_TYPE VARCHAR2(1) := P_PREV_DAY_COUNT_TYPE;
243:
244: cursor OLDEST_DATE is
245: select min(TRANSFER_DATE)
246: from xtr_intergroup_transfers
247: where party_code = PTY_CODE
248: and company_code = COMP_CODE
249: and currency = CCY;
250:

Line 306: XTR_INTERGROUP_TRANSFERS

302: CURSOR OLDEST_DATE IS
303: SELECT
304: MIN(TRANSFER_DATE)
305: FROM
306: XTR_INTERGROUP_TRANSFERS
307: WHERE PARTY_CODE = PTY_CODE
308: AND COMPANY_CODE = COMP_CODE
309: AND CURRENCY = CCY;
310: BEGIN

Line 365: XTR_INTERGROUP_TRANSFERS

361: CURSOR OLDEST_DATE IS
362: SELECT
363: MIN(TRANSFER_DATE)
364: FROM
365: XTR_INTERGROUP_TRANSFERS
366: WHERE PARTY_CODE = PTY_CODE
367: AND COMPANY_CODE = COMP_CODE
368: AND CURRENCY = CCY;
369: BEGIN

Line 410: XTR_INTERGROUP_TRANSFERS

406: CURSOR PRV_DATE IS
407: SELECT
408: MAX(TRANSFER_DATE)
409: FROM
410: XTR_INTERGROUP_TRANSFERS
411: WHERE COMPANY_CODE = COMP_CODE
412: AND PARTY_CODE = PTY_CODE
413: AND CURRENCY = CCY
414: AND TRANSFER_DATE <= TRANS_DATE

Line 436: XTR_INTERGROUP_TRANSFERS A

432: CURSOR PRV_RATE IS
433: SELECT
434: INTEREST_RATE
435: FROM
436: XTR_INTERGROUP_TRANSFERS A
437: WHERE COMPANY_CODE = COMP_CODE
438: AND PARTY_CODE = PTY_CODE
439: AND CURRENCY = CCY
440: AND TRANSFER_DATE = (

Line 444: XTR_INTERGROUP_TRANSFERS B

440: AND TRANSFER_DATE = (
441: SELECT
442: MAX(TRANSFER_DATE)
443: FROM
444: XTR_INTERGROUP_TRANSFERS B
445: WHERE A.DEAL_NUMBER = B.DEAL_NUMBER
446: AND TRANSFER_DATE < TRANS_DATE )
447: AND TRANSACTION_NUMBER = (
448: SELECT

Line 451: XTR_INTERGROUP_TRANSFERS C

447: AND TRANSACTION_NUMBER = (
448: SELECT
449: MAX(TRANSACTION_NUMBER)
450: FROM
451: XTR_INTERGROUP_TRANSFERS C
452: WHERE A.DEAL_NUMBER = C.DEAL_NUMBER
453: AND TRANSFER_DATE < TRANS_DATE );
454: BEGIN
455: OPEN PRV_RATE;

Line 473: XTR_INTERGROUP_TRANSFERS A

469: CURSOR BAL_BF IS
470: SELECT
471: BALANCE_OUT
472: FROM
473: XTR_INTERGROUP_TRANSFERS A
474: WHERE COMPANY_CODE = COMP_CODE
475: AND PARTY_CODE = PTY_CODE
476: AND CURRENCY = CCY
477: AND TRANSFER_DATE = (

Line 481: XTR_INTERGROUP_TRANSFERS B

477: AND TRANSFER_DATE = (
478: SELECT
479: MAX(TRANSFER_DATE)
480: FROM
481: XTR_INTERGROUP_TRANSFERS B
482: WHERE A.DEAL_NUMBER = B.DEAL_NUMBER
483: AND TRANSFER_DATE < TRANS_DATE )
484: AND TRANSACTION_NUMBER = (
485: SELECT

Line 488: XTR_INTERGROUP_TRANSFERS C

484: AND TRANSACTION_NUMBER = (
485: SELECT
486: MAX(TRANSACTION_NUMBER)
487: FROM
488: XTR_INTERGROUP_TRANSFERS C
489: WHERE A.DEAL_NUMBER = C.DEAL_NUMBER
490: AND TRANSFER_DATE < TRANS_DATE );
491: BEGIN
492: OPEN BAL_BF;