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 1433: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;

1429: P_CALLING_MODE IN VARCHAR2 DEFAULT 'PREPAYMENT APPLICATION',
1430: P_ERROR_MESSAGE OUT NOCOPY VARCHAR2) RETURN BOOLEAN
1431: IS
1432:
1433: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1434:
1435: -- Standard Invoice Related Variables
1436: l_std_inv_batch_id ap_invoices_all.batch_id%TYPE;
1437: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;

Line 1524: FROM ap_system_parameters;

1520: l_prepay_adjusted_amount NUMBER; --12888895
1521:
1522: CURSOR C_SYS_PARAMS IS
1523: SELECT base_currency_code
1524: FROM ap_system_parameters;
1525:
1526: CURSOR C_STD_INVOICE_INFO (CV_Std_Invoice_ID IN NUMBER) IS
1527: SELECT batch_id,
1528: invoice_currency_code,