DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PA_TASKS_EXPEND_V

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