APPS.CE_AUTO_BANK_CLEAR1 dependencies on AP_CHECKS_ALL

Line 60: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA

56: AND nvl(a.status, 'NEGOTIABLE') <> 'VOIDED'
57: AND a.application_id = 200
58: AND NVL(a.reconciled_status_flag, 'N') = 'N'
59: AND EXISTS ( SELECT 1
60: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA
61: WHERE ACA.CHECK_ID =a.trx_id
62: AND ACA.PAYMENT_INSTRUCTION_ID = pbatch_id
63: AND IPA.PAYMENT_INSTRUCTION_ID (+) = pbatch_id -- Bug # 8353600 Added Outer Join (+)
64: AND IPA.PAYMENT_ID (+) = ACA.PAYMENT_ID -- Bug # 8353600 Added Outer Join (+)

Line 95: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA

91: WHERE a.batch_id = pbatch_id
92: AND nvl(a.status, 'NEGOTIABLE') <> 'VOIDED'
93: -- FOR SEPA ER 6700007
94: AND EXISTS ( SELECT 1
95: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA
96: WHERE ACA.CHECK_ID =a.trx_id
97: AND ACA.PAYMENT_INSTRUCTION_ID = pbatch_id
98: AND IPA.PAYMENT_INSTRUCTION_ID (+) = pbatch_id -- Bug # 8353600 Added Outer Join (+)
99: AND IPA.PAYMENT_ID (+) = ACA.PAYMENT_ID -- Bug # 8353600 Added Outer Join (+)

Line 1504: check_id AP_CHECKS_ALL.check_id%TYPE;

1500: X_float_handling_flag VARCHAR2,
1501: X_bank_currency_code VARCHAR2,
1502: pgroup_id VARCHAR2 DEFAULT NULL -- FOR SEPA ER 6700007
1503: ) IS
1504: check_id AP_CHECKS_ALL.check_id%TYPE;
1505: check_status CE_LOOKUPS.lookup_code%TYPE;
1506: amount_cleared AP_CHECKS_ALL.cleared_amount%TYPE;
1507: auto_reconciled_flag VARCHAR2(1);
1508: batch_trx_type varchar2(30);

Line 1506: amount_cleared AP_CHECKS_ALL.cleared_amount%TYPE;

1502: pgroup_id VARCHAR2 DEFAULT NULL -- FOR SEPA ER 6700007
1503: ) IS
1504: check_id AP_CHECKS_ALL.check_id%TYPE;
1505: check_status CE_LOOKUPS.lookup_code%TYPE;
1506: amount_cleared AP_CHECKS_ALL.cleared_amount%TYPE;
1507: auto_reconciled_flag VARCHAR2(1);
1508: batch_trx_type varchar2(30);
1509: batch_app_id number;
1510: l_gt_seq_id number := to_number(null);

Line 1757: from ap_checks_all c

1753: set amount =
1754: (select DECODE(c.currency_code,
1755: X_bank_currency_code, c.cleared_amount,
1756: nvl(c.cleared_base_amount, c.cleared_amount*CE_AUTO_BANK_CLEAR.G_exchange_rate))
1757: from ap_checks_all c
1758: where c.check_id = r.reference_id)
1759: where statement_line_id = CE_AUTO_BANK_MATCH.csl_statement_line_id
1760: and reference_type = 'PAYMENT'
1761: and status_flag = 'M'