APPS.PO_AUTOCREATE_DOC dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 2050: from financials_system_params_all

2046: --Get default inventory org of purchasing org from the fsp_all table.
2047:
2048: select inventory_organization_id
2049: into x_inv_org_id
2050: from financials_system_params_all
2051: where org_id = l_purchasing_org_id;
2052:
2053: /* Now get the buyer from the item master. There may/may not be one
2054: * assigned to the item. MTL_SYSTEM_ITEMS is a table that isn't striped

Line 4273: from financials_system_params_all fsp,

4269:
4270: --begin bug 3401653
4271: select sob.currency_code, fsp.set_of_books_id
4272: into l_pou_currency_code, l_pou_sob_id
4273: from financials_system_params_all fsp,
4274: gl_sets_of_books sob
4275: where fsp.set_of_books_id = sob.set_of_books_id
4276: and fsp.org_id = l_purchasing_org_id; --
4277:

Line 4285: from financials_system_params_all fsp,

4281: where psp.org_id = l_purchasing_org_id; -- removed nvl --
4282:
4283: select sob.currency_code
4284: into l_rou_currency_code
4285: from financials_system_params_all fsp,
4286: gl_sets_of_books sob
4287: where fsp.set_of_books_id = sob.set_of_books_id
4288: and fsp.org_id = x_org_id;
4289: --end bug 3401653