DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG dependencies on AP_EXPENSE_REPORT_LINES_ALL

Line 1540: --5:TABLE ACCESS FULL AP_EXPENSE_REPORT_LINES_ALL :(cost=7,rows=1260)

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
1543: SELECT pbc.bc_packet_id,
1544: pbc.project_id,

Line 1566: ,ap_expense_report_lines_all expline

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
1570: AND exphead.report_header_id = expline.report_header_id /* added for bug#2634995 */