APPS.AP_RECONCILIATION_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 287: FROM ap_system_parameters asp,

283: SELECT asp.base_currency_code,
284: asp.org_id
285: INTO l_functional_currency_code,
286: l_org_id
287: FROM ap_system_parameters asp,
288: ap_checks ac
289: WHERE ac.org_id = asp.org_id
290: AND ac.check_id = x_check_id;
291:

Line 427: l_recon_accounting_flag ap_system_parameters.recon_accounting_flag%TYPE;

423: X_CALLING_SEQUENCE VARCHAR2
424: ) AS
425:
426: --bugfix:5623562
427: l_recon_accounting_flag ap_system_parameters.recon_accounting_flag%TYPE;
428: l_currency_case VARCHAR2(30);
429: l_status_code VARCHAR2(30) ;
430:
431: l_pmt_currency_code ap_checks.currency_code%TYPE;

Line 432: l_functional_currency_code ap_system_parameters.base_currency_code%TYPE;

428: l_currency_case VARCHAR2(30);
429: l_status_code VARCHAR2(30) ;
430:
431: l_pmt_currency_code ap_checks.currency_code%TYPE;
432: l_functional_currency_code ap_system_parameters.base_currency_code%TYPE;
433: l_bank_to_base_xrate ap_checks.exchange_rate%TYPE;
434: l_bank_to_base_xrate_type ap_checks.exchange_rate_type%TYPE;
435: l_bank_to_base_xrate_date ap_checks.exchange_date%TYPE;
436: l_trx_pmt_amount NUMBER;

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 523: FROM ap_system_parameters;

519: SELECT nvl(recon_accounting_flag, 'N'),
520: base_currency_code
521: INTO l_recon_accounting_flag,
522: l_functional_currency_code
523: FROM ap_system_parameters;
524: */
525: l_errors_bank_amount := nvl(X_ERRORS_BANK_AMOUNT,0);
526: l_charges_bank_amount := nvl(X_CHARGES_BANK_AMOUNT,0);
527:

Line 600: ap_system_parameters asp

596: l_functional_currency_code,
597: l_org_id,
598: l_recon_accounting_flag
599: FROM ap_checks ac,
600: ap_system_parameters asp
601: WHERE ac.checkrun_id = X_CHECKRUN_ID
602: AND asp.org_id = ac.org_id
603: AND ac.org_id = l_distinct_org
604: AND rownum = 1;

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 1432: l_recon_accounting_flag ap_system_parameters.recon_accounting_flag%TYPE;

1428: )
1429: AS
1430:
1431: --bgufix:5623562
1432: l_recon_accounting_flag ap_system_parameters.recon_accounting_flag%TYPE;
1433: l_check_amount ap_checks.amount%TYPE;
1434: l_rev_pmt_hist_id ap_payment_history.rev_pmt_hist_id%TYPE;
1435: l_check_id ap_checks.check_id%TYPE;
1436: l_ind_trx_bank_amount ap_payment_history.trx_bank_amount%TYPE;

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: