APPS.PO_AUTOCREATE_DOC dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 1833: from financials_system_params_all

1829: --Get default inventory org of purchasing org from the fsp_all table.
1830:
1831: select inventory_organization_id
1832: into x_inv_org_id
1833: from financials_system_params_all
1834: where org_id = l_purchasing_org_id;
1835:
1836: /* Now get the buyer from the item master. There may/may not be one
1837: * assigned to the item. MTL_SYSTEM_ITEMS is a table that isn't striped

Line 3948: from financials_system_params_all fsp,

3944:
3945: --begin bug 3401653
3946: select sob.currency_code, fsp.set_of_books_id
3947: into l_pou_currency_code, l_pou_sob_id
3948: from financials_system_params_all fsp,
3949: gl_sets_of_books sob
3950: where fsp.set_of_books_id = sob.set_of_books_id
3951: and fsp.org_id = l_purchasing_org_id; --
3952:

Line 3960: from financials_system_params_all fsp,

3956: where psp.org_id = l_purchasing_org_id; -- removed nvl --
3957:
3958: select sob.currency_code
3959: into l_rou_currency_code
3960: from financials_system_params_all fsp,
3961: gl_sets_of_books sob
3962: where fsp.set_of_books_id = sob.set_of_books_id
3963: and fsp.org_id = x_org_id;
3964: --end bug 3401653