[Home] [Help]
1521: --6:TABLE ACCESS BY INDEX ROWID PA_BC_PACKETS :(cost=120,rows=1)
1522: --7:INDEX RANGE SCAN PA_BC_PACKETS_U1 :(cost=5,rows=1)
1523: --6:TABLE ACCESS BY INDEX ROWID PA_EXPENDITURE_ITEMS_ALL :(cost=2,rows=2345)
1524: --7:INDEX RANGE SCAN PA_EXPENDITURE_ITEMS_N9 :(cost=1,rows=2345)
1525: --5:TABLE ACCESS BY INDEX ROWID PA_COST_DISTRIBUTION_LINES_ALL :(cost=15,rows=47647)
1526: --6:INDEX RANGE SCAN PA_COST_DISTRIBUTION_LINES_U1 :(cost=1,rows=47647)
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)
1537: pbc.project_id,
1538: nvl(exp.system_linkage_function,'VI') system_linkage_function,
1539: pbc.burden_method_code
1540: FROM pa_bc_packets pbc
1541: ,pa_cost_distribution_lines_all cdl
1542: ,pa_expenditure_items_all exp
1543: WHERE pbc.packet_id = p_packet_id
1544: AND pbc.document_header_id = cdl.system_reference2
1545: AND pbc.document_distribution_id = cdl.system_reference3
10032: -- cdls with gl_date,encumbrance type id, budget ccid and
10033: -- encumbrance amount for the R line .updating C and D lines
10034: -- will be done in Distribute Burden transaction process
10035: FORALL i IN g_tab_doc_header_id.FIRST .. g_tab_doc_header_id.LAST
10036: UPDATE pa_cost_distribution_lines_all
10037: SET --gl_date = g_tab_gl_date(i)
10038: budget_ccid = g_tab_budget_ccid(i)
10039: ,budget_version_id = g_tab_budget_version_id(i)
10040: ,budget_line_id = g_tab_budget_line_id(i)