DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PA_TASKS_EXPEND_V

Line 1098: FROM PA_TASKS_EXPEND_V task

1094: line_origination_code <> 'REQUISITION'
1095: AND pro_project_id IS NOT NULL
1096: AND project_task_number IS NOT NULL
1097: AND NOT EXISTS (SELECT 1
1098: FROM PA_TASKS_EXPEND_V task
1099: WHERE task.project_id = pro_project_id AND task.task_number = project_task_number) THEN
1100: INTO pon_interface_errors
1101: (
1102: interface_type, column_name, table_name, -- 1

Line 1126: PA_TASKS_EXPEND_V task

1122: AND project_task_number IS NOT NULL
1123: AND project_award_number IS NOT NULL
1124: AND NOT EXISTS (SELECT 1
1125: FROM GMS_AWARDS_BASIC_V award,
1126: PA_TASKS_EXPEND_V task
1127: WHERE award.project_id = pro_project_id
1128: AND task.task_number = project_task_number
1129: AND award.task_id = task.task_id
1130: AND task.project_id = pro_project_id) THEN

Line 1321: PA_TASKS_EXPEND_V task,

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
1325: WHERE pipi.project_number = pro.segment1