APPS.PO_AUTOCREATE_DOC dependencies on PO_SYSTEM_PARAMETERS

Line 4280: from po_system_parameters_all psp --

4276: and fsp.org_id = l_purchasing_org_id; --
4277:
4278: select default_rate_type
4279: into l_pou_default_rate_type
4280: from po_system_parameters_all psp --
4281: where psp.org_id = l_purchasing_org_id; -- removed nvl --
4282:
4283: select sob.currency_code
4284: into l_rou_currency_code

Line 5100: from po_system_parameters;

5096: and pass it to create_document proc*/
5097:
5098: select nvl(group_shipments_flag, 'Y')
5099: into x_group_shipments
5100: from po_system_parameters;
5101:
5102: --
5103:
5104: --

Line 6940: po_system_parameters PSP

6936: AND NVL(POH.frozen_flag, 'N') = 'N'
6937: AND (NVL(POH.global_agreement_flag, 'N') = 'N'
6938: OR EXISTS (SELECT 1
6939: FROM po_ga_org_assignments PGOA,
6940: po_system_parameters PSP
6941: WHERE PGOA.po_header_id = POH.po_header_id
6942: AND PGOA.organization_id = PSP.org_id
6943: AND PGOA.vendor_site_id = decode(Nvl(poh.Enable_All_Sites,'N'),'Y',PGOA.vendor_site_id, l_vendor_site_id) -- Bug#14157987
6944: AND PGOA.enabled_flag = 'Y'));