eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PURGE_VALIDATE_COSTING dependencies on AP_EXPENSE_REPORT_HEADERS

Line 348: from ap_expense_report_headers h,

344: cursor IsIexpenseTxnsPending IS
345: select 'Iexpense Transactions Pending'
346: from dual
347: where exists (select h.report_header_id
348: from ap_expense_report_headers h,
349: ap_expense_report_lines l
350: where h.report_header_id = l.report_header_id
351: and h.source <> 'Oracle Project Accounting'
352: and l.project_id = p_project_id

Line 365: from ap_expense_report_headers h,

361: select 'Iexpense Transactions Pending'
362: from dual
363: where exists (
364: select null
365: from ap_expense_report_headers h,
366: ap_expense_report_lines l
367: where l.project_id = p_project_id
368: and (p_active_flag <> 'A'
369: or (trunc(l.expenditure_item_date ) <=

Line 817: ' from ap_expense_report_headers h, '||

813: IF l_dummy_num > 1154 THEN
814: V_Stmt := 'select ' || '''Iexpense Transactions Pending''' ||
815: ' from dual '||
816: ' where exists (select h.report_header_id '||
817: ' from ap_expense_report_headers h, '||
818: ' ap_expense_report_lines l '||
819: ' where h.report_header_id = l.report_header_id '||
820: ' and h.source <> '||'''Oracle Project Accounting''' ||
821: ' and l.project_id = :p_proj_id '||