APPS.AP_WEB_UPGRADE_REPORT_DIST_PKG dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 19: l_table_name VARCHAR2(30) := 'AP_EXPENSE_REPORT_HEADERS_ALL';

15: ------------------------------------------------------------------------
16: l_request_id NUMBER;
17: l_request_status VARCHAR2(30);
18: l_any_rows_to_process boolean;
19: l_table_name VARCHAR2(30) := 'AP_EXPENSE_REPORT_HEADERS_ALL';
20: l_script_name VARCHAR2(30) := 'apwuprdb.pls';
21: l_product VARCHAR2(30) := 'SQLAP';
22: l_table_owner VARCHAR2(30);
23:

Line 121: ap_expense_report_headers_all xh,

117: xl.task_id,
118: xl.award_id,
119: xl.expenditure_organization_id
120: FROM ap_expense_report_lines_all xl,
121: ap_expense_report_headers_all xh,
122: gl_sets_of_books gs
123: WHERE xh.rowid BETWEEN l_start_rowid AND l_end_rowid
124: --Derive chart of accounts ID from set of books ID
125: AND gs.set_of_books_id = xl.set_of_books_id

Line 198: from AP_EXPENSE_REPORT_HEADERS_ALL xh

194: WHERE XL.code_combination_id IS NOT NULL
195: AND (XL.itemization_parent_id IS NULL
196: OR XL.itemization_parent_id <> -1)
197: AND EXISTS (select /*+ unnest rowid(xh) */ null
198: from AP_EXPENSE_REPORT_HEADERS_ALL xh
199: where xh.rowid between l_start_rowid and l_end_rowid
200: and xh.vouchno <> 0
201: and xh.report_header_id = xl.report_header_id);
202: