APPS.AP_R11_PREPAY_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 641: FROM ap_system_parameters;

637: Selected org_id also so that the same can be used for
638: insertion at later point of time */
639: SELECT base_currency_code,org_id
640: INTO X_base_currency,X_org_id
641: FROM ap_system_parameters;
642:
643:
644: ---------------------------------------------------------------------
645: -- Get the Min_unit and precision from ap_invoice

Line 672: FROM AP_SYSTEM_PARAMETERS);

668: SELECT MINIMUM_ACCOUNTABLE_UNIT, nvl(PRECISION,0)
669: INTO X_base_min_unit , X_base_precision
670: FROM FND_CURRENCIES
671: WHERE CURRENCY_CODE = ( SELECT BASE_CURRENCY_CODE
672: FROM AP_SYSTEM_PARAMETERS);
673:
674:
675: ---------------------------------------------------------------------
676: -- Get the Payment Currency Min_unit and precision from ap_invoice

Line 813: FROM gl_period_statuses G, ap_system_parameters P

809: if (X_period_name IS NULL) then
810: debug_info := 'Get period_name';
811: SELECT G.period_name
812: INTO X_period_name
813: FROM gl_period_statuses G, ap_system_parameters P
814: WHERE G.application_id = 200
815: AND G.set_of_books_id = P.set_of_books_id
816: AND DECODE(X_gl_date, '',
817: sysdate, X_gl_date) between G.start_date and G.end_date

Line 1782: FROM ap_invoice_payments P, ap_invoices I, ap_system_parameters ASP

1778: X_user_id,
1779: 'PREPAY',
1780: X_prepay_id,
1781: I.org_id /* Bug 3700128. MOAC Project */
1782: FROM ap_invoice_payments P, ap_invoices I, ap_system_parameters ASP
1783: WHERE I.invoice_id = X_new_invoice_id
1784: AND P.invoice_payment_id = X_copy_inv_pay_id
1785: AND ASP.set_of_books_id = I.set_of_books_id;
1786: