DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG dependencies on AP_EXPENSE_REPORT_LINES_ALL

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

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
1536: SELECT pbc.bc_packet_id,
1537: pbc.project_id,

Line 1559: ,ap_expense_report_lines_all expline

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