APPS.AP_RECONCILIATION_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 588: ap_system_parameters_all asp

584: asp.base_currency_code,
585: asp.org_id,
586: nvl(asp.recon_accounting_flag, 'N')
587: FROM ap_checks_all c,
588: ap_system_parameters_all asp
589: WHERE c.checkrun_id = X_CHECKRUN_id
590: AND c.org_id = p_org_id
591: AND c.org_id = asp.org_id
592: AND c.status_lookup_code NOT IN -- Bug 3408260

Line 1290: ap_system_parameters_all asp

1286: l_functional_currency_code,
1287: l_org_id,
1288: l_recon_accounting_flag
1289: FROM ap_checks_all c,
1290: ap_system_parameters_all asp
1291: WHERE c.check_id = X_CHECK_ID
1292: AND c.org_id = asp.org_id;
1293:
1294: IF ((l_status_lookup_code IN ('RECONCILED','RECONCILED UNACCOUNTED'))) THEN

Line 1894: FROM ap_system_parameters_all

1890:
1891: --bugfix:5623562
1892: SELECT nvl(recon_accounting_flag, 'N')
1893: INTO l_recon_accounting_flag
1894: FROM ap_system_parameters_all
1895: WHERE org_id = l_distinct_org ;
1896:
1897: IF (l_recon_accounting_flag = 'Y') THEN
1898:

Line 2015: FROM ap_system_parameters_all asp,

2011:
2012: --bugfix:5674397
2013: SELECT nvl(recon_accounting_flag, 'N')
2014: INTO l_recon_accounting_flag
2015: FROM ap_system_parameters_all asp,
2016: ap_checks_all ac
2017: WHERE asp.org_id = ac.org_id
2018: AND ac.check_id = X_CHECK_ID;
2019: