APPS.AP_RECONCILIATION_PKG dependencies on AP_CHECKS_ALL

Line 489: FROM ap_checks_all c,

485: c.currency_code,
486: asp.base_currency_code,
487: asp.org_id,
488: nvl(asp.recon_accounting_flag, 'N')
489: FROM ap_checks_all c,
490: ap_system_parameters_all asp
491: WHERE c.checkrun_id = X_CHECKRUN_id
492: AND c.org_id = p_org_id
493: AND c.org_id = asp.org_id

Line 1047: FROM ap_checks_all c,

1043: l_future_pay_flag,
1044: l_functional_currency_code,
1045: l_org_id,
1046: l_recon_accounting_flag
1047: FROM ap_checks_all c,
1048: ap_system_parameters_all asp
1049: WHERE c.check_id = X_CHECK_ID
1050: AND c.org_id = asp.org_id;
1051:

Line 1495: ap_checks_all C

1491: C.check_id,
1492: NVL(c.amount, 0),
1493: c.org_id
1494: FROM ap_payment_history_all APHA,
1495: ap_checks_all C
1496: WHERE APHA.check_id = C.check_id
1497: AND C.checkrun_id = X_CHECKRUN_ID
1498: AND C.org_id = p_org_id -- Bug 5674397
1499: AND APHA.transaction_type = 'PAYMENT CLEARING'

Line 1672: ap_checks_all ac

1668: --bugfix:5674397
1669: SELECT nvl(recon_accounting_flag, 'N')
1670: INTO l_recon_accounting_flag
1671: FROM ap_system_parameters_all asp,
1672: ap_checks_all ac
1673: WHERE asp.org_id = ac.org_id
1674: AND ac.check_id = X_CHECK_ID;
1675:
1676: --bugfix:5623562 -- 5674397