DBA Data[Home] [Help]

APPS.AP_INVOICES_UTILITY_PKG dependencies on AP_EXPENSE_REPORT_HEADERS

Line 2562: | information from ap expense report headers, if not we should get the

2558: | KNOWN ISSUES:
2559: |
2560: | NOTES
2561: | If the information is available in both the table we should get the
2562: | information from ap expense report headers, if not we should get the
2563: | information from ap invoices. This was added based on the requirement
2564: | from GSI and confirmed by lauren
2565: |
2566: | MODIFICATION HISTORY

Line 2583: FROM ap_expense_report_headers aerh

2579: IF p_source IN ('XpenseXpress', 'SelfService') THEN
2580:
2581: SELECT 'E'
2582: INTO l_return_type
2583: FROM ap_expense_report_headers aerh
2584: WHERE aerh.vouchno = p_invoice_id;
2585:
2586: ELSE
2587: