DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 1538: --6:TABLE ACCESS BY INDEX ROWID AP_EXPENSE_REPORT_HEADERS_ALL :(cost=1,rows=290)

1534: --4:NESTED LOOPS :(cost=128,rows=1)
1535: --5:NESTED LOOPS :(cost=121,rows=1)
1536: --6:TABLE ACCESS BY INDEX ROWID PA_BC_PACKETS :(cost=120,rows=1)
1537: --7:INDEX RANGE SCAN PA_BC_PACKETS_U1 :(cost=5,rows=1)
1538: --6:TABLE ACCESS BY INDEX ROWID AP_EXPENSE_REPORT_HEADERS_ALL :(cost=1,rows=290)
1539: --7:INDEX RANGE SCAN AP_EXPENSE_REPORT_HEADERS_N1 :(cost=,rows=290)
1540: --5:TABLE ACCESS FULL AP_EXPENSE_REPORT_LINES_ALL :(cost=7,rows=1260)
1541:
1542: CURSOR invoice_cdls is

Line 1565: ,ap_expense_report_headers_all exphead

1561: pbc.project_id,
1562: 'ER' system_linkage_function,
1563: pbc.burden_method_code
1564: FROM pa_bc_packets pbc
1565: ,ap_expense_report_headers_all exphead
1566: ,ap_expense_report_lines_all expline
1567: WHERE pbc.packet_id = p_packet_id
1568: AND pbc.document_header_id = exphead.vouchno
1569: AND pbc.set_of_books_id = exphead.set_of_books_id