DBA Data[Home] [Help]

APPS.PON_VALIDATE_PAYMENTS_INT dependencies on PA_TASKS_EXPEND_V

Line 689: FROM PA_TASKS_EXPEND_V task

685: WHEN line_origination_code <> 'REQUISITION'
686: AND pro_project_id IS NOT NULL
687: AND project_task_number IS NOT NULL
688: AND NOT EXISTS (SELECT 1
689: FROM PA_TASKS_EXPEND_V task
690: WHERE task.project_id = pro_project_id AND task.task_number = project_task_number) THEN
691: INTO pon_interface_errors
692: (
693: column_name, entity_attr_name, error_message_name, -- 1

Line 719: PA_TASKS_EXPEND_V task

715: AND project_task_number IS NOT NULL
716: AND project_award_number IS NOT NULL
717: AND NOT EXISTS (SELECT 1
718: FROM GMS_AWARDS_BASIC_V award,
719: PA_TASKS_EXPEND_V task
720: WHERE award.project_id = pro_project_id
721: AND task.task_number = project_task_number
722: AND award.task_id = task.task_id
723: AND task.project_id = pro_project_id) THEN