DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PA_PROJECTS_ALL

Line 1320: FROM PA_PROJECTS_ALL pro,

1316: --Derive id columns and update the interface table
1317: UPDATE PON_ITEM_PRICES_INTERFACE pipi1
1318: SET (PROJECT_ID, PROJECT_TASK_ID, PROJECT_AWARD_ID, PROJECT_EXP_ORGANIZATION_ID) =
1319: (SELECT pro.project_id, task.task_id, award.award_id, porg.organization_id
1320: FROM PA_PROJECTS_ALL pro,
1321: PA_TASKS_EXPEND_V task,
1322: GMS_AWARDS_ALL award,
1323: HR_ALL_ORGANIZATION_UNITS porg,
1324: PON_ITEM_PRICES_INTERFACE pipi