DBA Data[Home] [Help]

APPS.IGC_UPGRADE_DATA_R12 dependencies on PA_PROJECTS_ALL

Line 532: SELECT distinct segment1 INTO l_reference_4 FROM pa_projects_all p, pa_budget_versions bv

528: Put_Debug_Msg(l_full_path, 'Number of rows Inserted: ' || SQL%ROWCOUNT);
529: END IF;
530:
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;