DBA Data[Home] [Help]

APPS.PO_INVOICES_SV2 dependencies on AP_SYSTEM_PARAMETERS

Line 528: X_def_base_currency_code ap_system_parameters.base_currency_code%TYPE;

524:
525: /** Bug# 1176326 **/
526: X_curr_conversion_rate_date1 DATE;
527: X_curr_conversion_rate1 NUMBER;
528: X_def_base_currency_code ap_system_parameters.base_currency_code%TYPE;
529:
530: X_curr_accounting_date DATE;
531: X_curr_period_name gl_periods.period_name%TYPE;
532: /** Bug 586895 **/

Line 757: from ap_system_parameters;

753: ** the rate on the receipt date
754: */
755: select base_currency_code
756: into X_def_base_currency_code
757: from ap_system_parameters;
758:
759: X_curr_conversion_rate_date :=
760: Nvl(X_rcv_txns.currency_conversion_date, X_rcv_txns.transaction_date); -- Bug 8579970
761:

Line 935: from ap_system_parameters;

931: ** the rate on the receipt date
932: */
933: select base_currency_code
934: into X_def_base_currency_code
935: from ap_system_parameters;
936:
937: X_curr_conversion_rate_date1 :=
938: Nvl(X_rcv_txns.currency_conversion_date, X_rcv_txns.transaction_date); -- Bug 8579970
939:

Line 2773: l_def_base_currency_code ap_system_parameters.base_currency_code%TYPE;

2769: l_first_flag VARCHAR2(1) := FND_API.G_TRUE;
2770:
2771: l_aging_period NUMBER;
2772: l_cutoff_date DATE;
2773: l_def_base_currency_code ap_system_parameters.base_currency_code%TYPE;
2774: l_org_id po_headers.org_id%TYPE;
2775: l_invoice_desc ap_invoices_interface.description%TYPE;
2776:
2777: l_group_id ap_invoices_interface.group_id%TYPE;

Line 2848: FROM ap_system_parameters;

2844:
2845: -- get base currency
2846: SELECT base_currency_code
2847: INTO l_def_base_currency_code
2848: FROM ap_system_parameters;
2849:
2850: IF (g_asn_debug = 'Y') THEN
2851: ASN_DEBUG.put_line('Base Currency Code = ' || l_def_base_currency_code);
2852: END IF;