APPS.PO_AP_MERGE_GRP dependencies on PO_GA_ORG_ASSIGNMENTS

Line 217: po_ga_org_assignments PGOA

213: FROM dual
214: WHERE EXISTS (
215: SELECT NULL
216: FROM po_headers GA,
217: po_ga_org_assignments PGOA
218: WHERE GA.global_agreement_flag = 'Y'
219: AND GA.vendor_id = p_from_vendor_id
220: AND GA.vendor_site_id = p_from_site_id
221: AND GA.po_header_id = PGOA.po_header_id

Line 332: po_ga_org_assignments PGOA

328: FROM dual
329: WHERE EXISTS (
330: SELECT NULL
331: FROM po_headers_all GA,
332: po_ga_org_assignments PGOA
333: WHERE GA.global_agreement_flag = 'Y'
334: AND GA.vendor_id = p_from_vendor_id
335: AND GA.po_header_id = PGOA.po_header_id
336: AND PGOA.vendor_site_id = p_from_site_id

Line 802: UPDATE po_ga_org_assignments PGOA

798: -- Starting from 11i FPJ we no longer update ga org assignments based on
799: -- vendor site code. Instead we just need to update org assignment with
800: -- vendor site id that matches p_from_vendor_id
801:
802: UPDATE po_ga_org_assignments PGOA
803: SET PGOA.vendor_site_id = p_to_site_id,
804: -- Bug 3387904 START - Need to update the WHO columns:
805: PGOA.last_update_date = SYSDATE,
806: PGOA.last_updated_by = FND_GLOBAL.user_id,

Line 811: UPDATE po_ga_org_assignments_archive PGOA

807: PGOA.last_update_login = FND_GLOBAL.login_id
808: -- Bug 3387904 END
809: WHERE PGOA.vendor_site_id = p_from_site_id;
810:
811: UPDATE po_ga_org_assignments_archive PGOA
812: SET PGOA.vendor_site_id = p_to_site_id,
813: -- Bug 3387904 START - Need to update the WHO columns:
814: PGOA.last_update_date = SYSDATE,
815: PGOA.last_updated_by = FND_GLOBAL.user_id,