DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on GMS_AWARDS_ALL

Line 1271: GMS_AWARDS_ALL award,

1267: SET (PROJECT_ID, PROJECT_TASK_ID, PROJECT_AWARD_ID, PROJECT_EXP_ORGANIZATION_ID) =
1268: (SELECT pro.project_id, task.task_id, award.award_id, porg.organization_id
1269: FROM PA_PROJECTS_ALL pro,
1270: PA_TASKS task,
1271: GMS_AWARDS_ALL award,
1272: HR_ALL_ORGANIZATION_UNITS porg,
1273: PON_ITEM_PRICES_INTERFACE pipi
1274: WHERE pipi.project_number = pro.segment1
1275: AND pipi.project_task_number = task.task_number