DBA Data[Home] [Help]

APPS.PO_DOCUMENT_REVISION_GRP dependencies on PO_GA_ORG_ASSIGNMENTS_ARCHIVE

Line 885: po_ga_org_assignments_archive pgoaa

881: -- revision is needed
882: SELECT 'Y'
883: INTO x_different
884: FROM po_ga_org_assignments pgoa,
885: po_ga_org_assignments_archive pgoaa
886: WHERE pgoa.po_header_id = p_doc_id
887: AND pgoa.po_header_id = pgoaa.po_header_id (+)
888: AND pgoa.organization_id = pgoaa.organization_id (+)
889: AND pgoaa.latest_external_flag (+) = 'Y'