DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PA_PROJECTS_ALL

Line 1269: FROM PA_PROJECTS_ALL pro,

1265: --Derive id columns and update the interface table
1266: UPDATE PON_ITEM_PRICES_INTERFACE pipi1
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