6192: -- hence even if it takes more memory because of project views, this query will be rarely executed
6193: INSERT ALL
6194: WHEN pai_project_id IS NOT NULL
6195: AND NOT EXISTS(SELECT 1
6196: FROM pa_projects_expend_v pro
6197: WHERE pro.project_id = pai_project_id) THEN
6198: INTO pon_interface_errors
6199: (
6200: interface_type, error_message_name, batch_id, -- 2
6822: -- Validate projects fields separately because of bug 4933437
6823: INSERT ALL
6824: WHEN s_project_id IS NOT NULL
6825: AND NOT EXISTS(SELECT 1
6826: FROM pa_projects_expend_v pro
6827: WHERE pro.project_id = s_project_id) THEN
6828: INTO pon_interface_errors
6829: (
6830: column_name, entity_attr_name, error_message_name, -- 1