APPS.XTR_AUTO_RECONCILIATION dependencies on XTR_RECONCILIATION_PROCESS

Line 336: from XTR_RECONCILIATION_PROCESS rp

332: and dda.DATE_TYPE <> 'COMENCE' -- bug 3045394
333: -- and substr( nvl(dda.RECONCILED_PASS_CODE, '@'), 1, 1) = '^'
334: and ( nvl(p_calling_method, 'AUTO') = 'MANUAL' OR
335: exists(select 'anyrow'
336: from XTR_RECONCILIATION_PROCESS rp
337: where rp.VERIFICATION_METHOD = nvl(p_verification_method,rp.VERIFICATION_METHOD)
338: and rp.RECONCILED_PASS_CODE = substr(dda.RECONCILED_PASS_CODE,2)
339: and nvl(rp.PROCESS_TYPE, 'M') = 'A'))
340: order by DEAL_NUMBER,TRANSACTION_NUMBER;

Line 1229: from XTR_RECONCILIATION_PROCESS

1225: l_sum_range VARCHAR2(1);l_deal_type VARCHAR2(7);l_subtype VARCHAR2(7);
1226: l_product VARCHAR2(10);l_portfolio VARCHAR2(7); l_rec_nos number;
1227: cursor PASSES is
1228: select RECONCILED_PASS_CODE,nvl(DAYS_ADJUSTMENT,0)
1229: from XTR_RECONCILIATION_PROCESS
1230: where VERIFICATION_METHOD = P_VERIFICATION_METHOD
1231: -- and PROCESS_TYPE = 'A'
1232: order by SEQUENCE_ORDER asc;
1233: cursor PASS_DETAILS is