APPS.XTR_AUTO_RECONCILIATION dependencies on XTR_RECONCILIATION_PROCESS

Line 444: from XTR_RECONCILIATION_PROCESS rp

440: and dda.DATE_TYPE <> 'COMENCE' -- bug 3045394
441: -- and substr( nvl(dda.RECONCILED_PASS_CODE, '@'), 1, 1) = '^'
442: and ( nvl(p_calling_method, 'AUTO') = 'MANUAL' OR
443: exists(select 'anyrow'
444: from XTR_RECONCILIATION_PROCESS rp
445: where rp.VERIFICATION_METHOD = nvl(p_verification_method,rp.VERIFICATION_METHOD)
446: and rp.RECONCILED_PASS_CODE = substr(dda.RECONCILED_PASS_CODE,2)
447: and nvl(rp.PROCESS_TYPE, 'M') = 'A'))
448: order by DEAL_NUMBER,TRANSACTION_NUMBER;

Line 613: from XTR_RECONCILIATION_PROCESS rp

609: and dda.DATE_TYPE <> 'COMENCE' -- bug 3045394
610: -- and substr( nvl(dda.RECONCILED_PASS_CODE, '@'), 1, 1) = '^'
611: and ( nvl(p_calling_method, 'AUTO') = 'MANUAL' OR
612: exists(select 'anyrow'
613: from XTR_RECONCILIATION_PROCESS rp
614: where rp.VERIFICATION_METHOD = nvl(p_verification_method,rp.VERIFICATION_METHOD)
615: and rp.RECONCILED_PASS_CODE = substr(dda.RECONCILED_PASS_CODE,2)
616: and nvl(rp.PROCESS_TYPE, 'M') = 'A'))
617: order by DEAL_NUMBER,TRANSACTION_NUMBER;

Line 1506: from XTR_RECONCILIATION_PROCESS

1502: l_sum_range VARCHAR2(1);l_deal_type VARCHAR2(7);l_subtype VARCHAR2(7);
1503: l_product VARCHAR2(10);l_portfolio VARCHAR2(7); l_rec_nos number;
1504: cursor PASSES is
1505: select RECONCILED_PASS_CODE,nvl(DAYS_ADJUSTMENT,0)
1506: from XTR_RECONCILIATION_PROCESS
1507: where VERIFICATION_METHOD = P_VERIFICATION_METHOD
1508: -- and PROCESS_TYPE = 'A'
1509: order by SEQUENCE_ORDER asc;
1510: cursor PASS_DETAILS is