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
64: AND IPA.PAYMENT_ID = ACA.PAYMENT_ID

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
99: AND IPA.PAYMENT_ID = ACA.PAYMENT_ID

Line 1478: check_id AP_CHECKS_ALL.check_id%TYPE;

1474: X_float_handling_flag VARCHAR2,
1475: X_bank_currency_code VARCHAR2,
1476: pgroup_id VARCHAR2 DEFAULT NULL -- FOR SEPA ER 6700007
1477: ) IS
1478: check_id AP_CHECKS_ALL.check_id%TYPE;
1479: check_status CE_LOOKUPS.lookup_code%TYPE;
1480: amount_cleared AP_CHECKS_ALL.cleared_amount%TYPE;
1481: auto_reconciled_flag VARCHAR2(1);
1482: batch_trx_type varchar2(30);

Line 1480: amount_cleared AP_CHECKS_ALL.cleared_amount%TYPE;

1476: pgroup_id VARCHAR2 DEFAULT NULL -- FOR SEPA ER 6700007
1477: ) IS
1478: check_id AP_CHECKS_ALL.check_id%TYPE;
1479: check_status CE_LOOKUPS.lookup_code%TYPE;
1480: amount_cleared AP_CHECKS_ALL.cleared_amount%TYPE;
1481: auto_reconciled_flag VARCHAR2(1);
1482: batch_trx_type varchar2(30);
1483: batch_app_id number;
1484: l_gt_seq_id number := to_number(null);

Line 1726: from ap_checks_all c

1722: set amount =
1723: (select DECODE(c.currency_code,
1724: X_bank_currency_code, c.cleared_amount,
1725: nvl(c.cleared_base_amount, c.cleared_amount*CE_AUTO_BANK_CLEAR.G_exchange_rate))
1726: from ap_checks_all c
1727: where c.check_id = r.reference_id)
1728: where statement_line_id = CE_AUTO_BANK_MATCH.csl_statement_line_id
1729: and reference_type = 'PAYMENT'
1730: and status_flag = 'M'