DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on PA_PROJECTS_EXPEND_V

Line 6196: FROM pa_projects_expend_v pro

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

Line 6826: FROM pa_projects_expend_v pro

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