DBA Data[Home] [Help]

APPS.PON_VALIDATE_PAYMENTS_INT dependencies on PA_TASKS_EXPEND_V

Line 635: PA_TASKS_EXPEND_V task,

631: pro.project_id, task.task_id, porg.organization_id,
632: papi.project_expenditure_type,papi.project_expenditure_item_date,
633: papi.auction_header_id, papi.payment_display_number
634: FROM PA_PROJECTS_ALL pro,
635: PA_TASKS_EXPEND_V task,
636: HR_ALL_ORGANIZATION_UNITS porg,
637: PON_AUC_PAYMENTS_INTERFACE papi
638: WHERE papi.project_number = pro.segment1
639: AND papi.project_task_number = task.task_number

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