APPS.PO_INTERFACE_S2 dependencies on PO_GA_ORG_ASSIGNMENTS

Line 96: FROM po_ga_org_assignments PGOA

92: AND ((PH.global_agreement_flag = 'Y'
93: AND PH.currency_code = x_currency
94: AND (ph.vendor_site_id = p_vendor_site_id --
95: OR EXISTS (SELECT 1
96: FROM po_ga_org_assignments PGOA
97: WHERE PGOA.po_header_id = PH.po_header_id
98: AND PGOA.enabled_flag = 'Y'
99: AND PGOA.vendor_site_id = decode(Nvl(PH.Enable_All_Sites,'N'),'N',p_vendor_site_id, PGOA.vendor_site_id ))))
100: OR

Line 122: FROM po_ga_org_assignments PGOA

118: --Need to ensure the site is header site or one of the
119: --purchasing site on Global Agreement
120: AND (ph.vendor_site_id = p_vendor_site_id
121: OR EXISTS (SELECT 1
122: FROM po_ga_org_assignments PGOA
123: WHERE PGOA.po_header_id = x_source_header_id
124: AND PGOA.enabled_flag = 'Y'
125: AND PGOA.vendor_site_id = p_vendor_site_id)))
126: OR (ph.type_lookup_code = 'QUOTATION'