DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on GMS_AWARDS_BASIC_V

Line 5386: FROM GMS_AWARDS_BASIC_V award

5382: WHEN pai_project_id IS NOT NULL
5383: AND pai_project_task_id IS NOT NULL
5384: AND pai_project_award_id IS NOT NULL
5385: AND NOT EXISTS (SELECT 1
5386: FROM GMS_AWARDS_BASIC_V award
5387: WHERE award.project_id = pai_project_id
5388: AND award.task_id = pai_project_task_id
5389: AND award.award_id = pai_project_award_id) THEN
5390: INTO pon_interface_errors

Line 6024: FROM GMS_AWARDS_BASIC_V award

6020: WHEN s_project_id IS NOT NULL
6021: AND s_project_task_id IS NOT NULL
6022: AND s_project_award_id IS NOT NULL
6023: AND NOT EXISTS (SELECT 1
6024: FROM GMS_AWARDS_BASIC_V award
6025: WHERE award.project_id = s_project_id
6026: AND award.task_id = s_project_task_id
6027: AND award.award_id = s_project_award_id) THEN
6028: INTO pon_interface_errors