DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PA_TASKS

Line 1054: FROM PA_TASKS_EXPEND_V task

1050: WHEN line_origination_code <> 'REQUISITION'
1051: AND pro_project_id IS NOT NULL
1052: AND project_task_number IS NOT NULL
1053: AND NOT EXISTS (SELECT 1
1054: FROM PA_TASKS_EXPEND_V task
1055: WHERE task.project_id = pro_project_id AND task.task_number = project_task_number) THEN
1056: INTO pon_interface_errors
1057: (
1058: interface_type, column_name, table_name, -- 1

Line 1081: PA_TASKS_EXPEND_V task

1077: AND project_task_number IS NOT NULL
1078: AND project_award_number IS NOT NULL
1079: AND NOT EXISTS (SELECT 1
1080: FROM GMS_AWARDS_BASIC_V award,
1081: PA_TASKS_EXPEND_V task
1082: WHERE award.project_id = pro_project_id
1083: AND task.task_number = project_task_number
1084: AND award.task_id = task.task_id
1085: AND task.project_id = pro_project_id) THEN

Line 1270: PA_TASKS task,

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