DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

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

1527: --4:NESTED LOOPS :(cost=128,rows=1)
1528: --5:NESTED LOOPS :(cost=121,rows=1)
1529: --6:TABLE ACCESS BY INDEX ROWID PA_BC_PACKETS :(cost=120,rows=1)
1530: --7:INDEX RANGE SCAN PA_BC_PACKETS_U1 :(cost=5,rows=1)
1531: --6:TABLE ACCESS BY INDEX ROWID AP_EXPENSE_REPORT_HEADERS_ALL :(cost=1,rows=290)
1532: --7:INDEX RANGE SCAN AP_EXPENSE_REPORT_HEADERS_N1 :(cost=,rows=290)
1533: --5:TABLE ACCESS FULL AP_EXPENSE_REPORT_LINES_ALL :(cost=7,rows=1260)
1534:
1535: CURSOR invoice_cdls is

Line 1558: ,ap_expense_report_headers_all exphead

1554: pbc.project_id,
1555: 'ER' system_linkage_function,
1556: pbc.burden_method_code
1557: FROM pa_bc_packets pbc
1558: ,ap_expense_report_headers_all exphead
1559: ,ap_expense_report_lines_all expline
1560: WHERE pbc.packet_id = p_packet_id
1561: AND pbc.document_header_id = exphead.vouchno
1562: AND pbc.set_of_books_id = exphead.set_of_books_id