DBA Data[Home] [Help]

APPS.JE_JEFILPIP_XMLP_PKG dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 265: FINANCIALS_SYSTEM_PARAMETERS;

261: SELECT
262: PURCH_ENCUMBRANCE_FLAG
263: INTO ENCUMBRANCE_FLAG
264: FROM
265: FINANCIALS_SYSTEM_PARAMETERS;
266: IF P_MATCH_STATUS_FLAG = 'A' THEN
267: SQL_DISTRIBUTIONS := 'and not exists' || '((select aid1.invoice_id from ap_invoice_distributions aid1' || ' where aid1.invoice_id = id.invoice_id';
268: IF NVL(ENCUMBRANCE_FLAG,'N') = 'Y' THEN
269: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || ' and nvl(aid1.match_status_flag,''N'') <> ''A'') ';