DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on GMS_AWARDS_BASIC_V

Line 6241: FROM GMS_AWARDS_BASIC_V award

6237: WHEN pai_project_id IS NOT NULL
6238: AND pai_project_task_id IS NOT NULL
6239: AND pai_project_award_id IS NOT NULL
6240: AND NOT EXISTS (SELECT 1
6241: FROM GMS_AWARDS_BASIC_V award
6242: WHERE award.project_id = pai_project_id
6243: AND award.task_id = pai_project_task_id
6244: AND award.award_id = pai_project_award_id) THEN
6245: INTO pon_interface_errors

Line 6881: FROM GMS_AWARDS_BASIC_V award

6877: WHEN s_project_id IS NOT NULL
6878: AND s_project_task_id IS NOT NULL
6879: AND s_project_award_id IS NOT NULL
6880: AND NOT EXISTS (SELECT 1
6881: FROM GMS_AWARDS_BASIC_V award
6882: WHERE award.project_id = s_project_id
6883: AND award.task_id = s_project_task_id
6884: AND award.award_id = s_project_award_id) THEN
6885: INTO pon_interface_errors