DBA Data[Home] [Help]

APPS.PA_ALTERNATE_TASK_PVT dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 766: AND EXISTS ( SELECT 1 FROM AP_EXPENSE_REPORT_HEADERS_ALL B

762: INTO x_exist
763: FROM AP_EXPENSE_REPORT_LINES_ALL A
764: WHERE A.TASK_ID IS NOT NULL
765: AND A.TASK_ID = p_Alt_Task_Id(i)
766: AND EXISTS ( SELECT 1 FROM AP_EXPENSE_REPORT_HEADERS_ALL B
767: WHERE A.REPORT_HEADER_ID = B.REPORT_HEADER_ID
768: AND B.SOURCE <> 'Oracle Project Accounting'
769: AND B.VOUCHNO = 0)
770: AND rownum = 1;