APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 1532: --5:TABLE ACCESS BY INDEX ROWID PA_COST_DISTRIBUTION_LINES_ALL :(cost=15,rows=47647)

1528: --6:TABLE ACCESS BY INDEX ROWID PA_BC_PACKETS :(cost=120,rows=1)
1529: --7:INDEX RANGE SCAN PA_BC_PACKETS_U1 :(cost=5,rows=1)
1530: --6:TABLE ACCESS BY INDEX ROWID PA_EXPENDITURE_ITEMS_ALL :(cost=2,rows=2345)
1531: --7:INDEX RANGE SCAN PA_EXPENDITURE_ITEMS_N9 :(cost=1,rows=2345)
1532: --5:TABLE ACCESS BY INDEX ROWID PA_COST_DISTRIBUTION_LINES_ALL :(cost=15,rows=47647)
1533: --6:INDEX RANGE SCAN PA_COST_DISTRIBUTION_LINES_U1 :(cost=1,rows=47647)
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)

Line 1548: ,pa_cost_distribution_lines_all cdl

1544: pbc.project_id,
1545: nvl(exp.system_linkage_function,'VI') system_linkage_function,
1546: pbc.burden_method_code
1547: FROM pa_bc_packets pbc
1548: ,pa_cost_distribution_lines_all cdl
1549: ,pa_expenditure_items_all exp
1550: WHERE pbc.packet_id = p_packet_id
1551: AND pbc.document_header_id = cdl.system_reference2
1552: AND pbc.document_distribution_id = cdl.system_reference3

Line 10293: UPDATE pa_cost_distribution_lines_all

10289: -- cdls with gl_date,encumbrance type id, budget ccid and
10290: -- encumbrance amount for the R line .updating C and D lines
10291: -- will be done in Distribute Burden transaction process
10292: FORALL i IN g_tab_doc_header_id.FIRST .. g_tab_doc_header_id.LAST
10293: UPDATE pa_cost_distribution_lines_all
10294: SET --gl_date = g_tab_gl_date(i)
10295: budget_ccid = g_tab_budget_ccid(i)
10296: ,budget_version_id = g_tab_budget_version_id(i)
10297: ,budget_line_id = g_tab_budget_line_id(i)