DBA Data[Home] [Help]

APPS.AP_RECONCILIATION_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 490: ap_system_parameters_all asp

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
494: AND c.status_lookup_code NOT IN -- Bug 3408260

Line 1048: ap_system_parameters_all asp

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:
1052: IF ((l_status_lookup_code IN ('RECONCILED','RECONCILED UNACCOUNTED'))) THEN

Line 1562: FROM ap_system_parameters_all

1558:
1559: --bugfix:5623562
1560: SELECT nvl(recon_accounting_flag, 'N')
1561: INTO l_recon_accounting_flag
1562: FROM ap_system_parameters_all
1563: WHERE org_id = l_distinct_org ;
1564:
1565: IF (l_recon_accounting_flag = 'Y') THEN
1566:

Line 1671: FROM ap_system_parameters_all asp,

1667:
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: