APPS.AP_PREPAY_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 86: FROM ap_system_parameters)

82: WHERE invoice_num = cv_prepay_num
83: AND vendor_id = cv_vendor_id
84: AND cv_base_currency_code =
85: (SELECT base_currency_code
86: FROM ap_system_parameters)
87: AND ai.invoice_currency_code = cv_invoice_currency_code
88: AND ai.payment_currency_code = NVL(cv_payment_currency_code,
89: cv_invoice_currency_code);
90: BEGIN

Line 392: ap_system_parameters P

388: CURSOR C_Get_Period_Name
389: (cv_gl_date DATE) IS
390: SELECT G.period_name
391: FROM gl_period_statuses G,
392: ap_system_parameters P
393: WHERE G.application_id = 200
394: AND G.set_of_books_id = P.set_of_books_id
395: AND TRUNC(cv_gl_date) BETWEEN G.start_date AND
396: G.end_date

Line 1411: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;

1407: P_CALLING_MODE IN VARCHAR2 DEFAULT 'PREPAYMENT APPLICATION',
1408: P_ERROR_MESSAGE OUT NOCOPY VARCHAR2) RETURN BOOLEAN
1409: IS
1410:
1411: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1412:
1413: -- Standard Invoice Related Variables
1414: l_std_inv_batch_id ap_invoices_all.batch_id%TYPE;
1415: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;

Line 1498: FROM ap_system_parameters;

1494: l_prepay_excl_tax_amt NUMBER; --5224883
1495:
1496: CURSOR C_SYS_PARAMS IS
1497: SELECT base_currency_code
1498: FROM ap_system_parameters;
1499:
1500: CURSOR C_STD_INVOICE_INFO (CV_Std_Invoice_ID IN NUMBER) IS
1501: SELECT batch_id,
1502: invoice_currency_code,