APPS.PA_PURGE_VALIDATE_COSTING dependencies on AP_EXPENSE_REPORT_LINES

Line 343: added to ap_expense_report_lines table in release 11.5.3 bug 2695986

339: and nvl(pt.unassigned_time, 'N') = 'Y' );
340:
341: /* Check for project related iExpense transactions Pending for import */
342: /* This portion has been done dynamically since pa_interfaced_flag is not
343: added to ap_expense_report_lines table in release 11.5.3 bug 2695986
344: cursor IsIexpenseTxnsPending IS
345: select 'Iexpense Transactions Pending'
346: from dual
347: where exists (select h.report_header_id

Line 349: ap_expense_report_lines l

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
353: and ( p_active_flag <> 'A'

Line 366: ap_expense_report_lines l

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 ) <=
370: trunc(p_txn_to_date )))

Line 818: ' ap_expense_report_lines l '||

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 '||
822: ' and ( :p_act_flag <> '|| '''A''' ||