DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on PA_PROJECTS_EXPEND_V

Line 5341: FROM pa_projects_expend_v pro

5337: -- hence even if it takes more memory because of project views, this query will be rarely executed
5338: INSERT ALL
5339: WHEN pai_project_id IS NOT NULL
5340: AND NOT EXISTS(SELECT 1
5341: FROM pa_projects_expend_v pro
5342: WHERE pro.project_id = pai_project_id) THEN
5343: INTO pon_interface_errors
5344: (
5345: interface_type, error_message_name, batch_id, -- 2

Line 5969: FROM pa_projects_expend_v pro

5965: -- Validate projects fields separately because of bug 4933437
5966: INSERT ALL
5967: WHEN s_project_id IS NOT NULL
5968: AND NOT EXISTS(SELECT 1
5969: FROM pa_projects_expend_v pro
5970: WHERE pro.project_id = s_project_id) THEN
5971: INTO pon_interface_errors
5972: (
5973: column_name, entity_attr_name, error_message_name, -- 1