APPS.PA_PROJ_TSK_UTILS dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 2478: where EXISTS (select * from ap_expense_report_lines_all a, ap_expense_report_headers_all b

2474: -- anlee
2475: /* Commented out for bug 2790785
2476: select 1 into x_exist
2477: from dual
2478: where EXISTS (select * from ap_expense_report_lines_all a, ap_expense_report_headers_all b
2479: where a.task_id = x_task_id
2480: and a.REPORT_HEADER_ID = b.REPORT_HEADER_ID
2481: and b.source <> 'Oracle Project Accounting');
2482: */

Line 2487: WHERE EXISTS (SELECT * FROM AP_EXPENSE_REPORT_LINES_ALL A, AP_EXPENSE_REPORT_HEADERS_ALL B

2483: /* Commented for bug 4060239
2484: -- Fix from bug 2790785
2485: SELECT 1 into x_exist
2486: FROM DUAL
2487: WHERE EXISTS (SELECT * FROM AP_EXPENSE_REPORT_LINES_ALL A, AP_EXPENSE_REPORT_HEADERS_ALL B
2488: WHERE A.TASK_ID = x_task_id
2489: AND A.REPORT_HEADER_ID = B.REPORT_HEADER_ID
2490: AND B.SOURCE <> 'Oracle Project Accounting'
2491: AND B.VOUCHNO = 0);

Line 2505: AP_EXPENSE_REPORT_HEADERS_ALL B

2501: /* Commented and modfied for Bug#5839405
2502: SELECT 1
2503: INTO x_exist
2504: FROM AP_EXPENSE_REPORT_LINES_ALL A,
2505: AP_EXPENSE_REPORT_HEADERS_ALL B
2506: WHERE A.TASK_ID = x_task_id
2507: AND A.REPORT_HEADER_ID = B.REPORT_HEADER_ID
2508: AND A.CREATION_DATE >= l_task_cdate
2509: AND B.CREATION_DATE >= l_task_cdate

Line 2521: AND EXISTS ( SELECT 1 FROM AP_EXPENSE_REPORT_HEADERS_ALL B

2517: FROM AP_EXPENSE_REPORT_LINES_ALL A
2518: WHERE A.TASK_ID IS NOT NULL
2519: AND A.TASK_ID = x_task_id
2520: AND A.CREATION_DATE >= l_task_cdate
2521: AND EXISTS ( SELECT 1 FROM AP_EXPENSE_REPORT_HEADERS_ALL B
2522: WHERE A.REPORT_HEADER_ID = B.REPORT_HEADER_ID
2523: AND B.CREATION_DATE >= l_task_cdate
2524: AND B.SOURCE <> 'Oracle Project Accounting'
2525: AND B.VOUCHNO = 0)