DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_DOC dependencies on PO_SYSTEM_PARAMETERS

Line 3955: from po_system_parameters_all psp --

3951: and fsp.org_id = l_purchasing_org_id; --
3952:
3953: select default_rate_type
3954: into l_pou_default_rate_type
3955: from po_system_parameters_all psp --
3956: where psp.org_id = l_purchasing_org_id; -- removed nvl --
3957:
3958: select sob.currency_code
3959: into l_rou_currency_code

Line 6488: po_system_parameters PSP

6484: AND NVL(POH.frozen_flag, 'N') = 'N'
6485: AND (NVL(POH.global_agreement_flag, 'N') = 'N'
6486: OR EXISTS (SELECT 1
6487: FROM po_ga_org_assignments PGOA,
6488: po_system_parameters PSP
6489: WHERE PGOA.po_header_id = POH.po_header_id
6490: AND PGOA.organization_id = PSP.org_id
6491: AND PGOA.vendor_site_id = l_vendor_site_id
6492: AND PGOA.enabled_flag = 'Y'));