DBA Data[Home] [Help]

APPS.IGC_UPGRADE_DATA_R12 dependencies on PO_HEADERS_ALL

Line 535: SELECT distinct segment1 INTO l_reference_4 FROM PO_HEADERS_ALL

531: IF (l_cbc_je_lines.JE_SOURCE = 'Project Accounting') THEN
532: SELECT distinct segment1 INTO l_reference_4 FROM pa_projects_all p, pa_budget_versions bv
533: WHERE p.project_id = bv.project_id AND bv.budget_version_id = p_cc_header_id;
534: ELSIF (l_cbc_je_lines.JE_SOURCE = 'Purchasing') THEN
535: SELECT distinct segment1 INTO l_reference_4 FROM PO_HEADERS_ALL
536: WHERE po_header_id = p_cc_header_id;
537: ELSIF (l_cbc_je_lines.JE_SOURCE = 'Requisitions') THEN
538: SELECT distinct segment1 INTO l_reference_4 FROM PO_REQUISITION_HEADERS_ALL
539: WHERE requisition_header_id = p_cc_header_id;