APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 1530: --6:TABLE ACCESS BY INDEX ROWID PA_EXPENDITURE_ITEMS_ALL :(cost=2,rows=2345)

1526: --4:NESTED LOOPS :(cost=137,rows=1)
1527: --5:NESTED LOOPS :(cost=122,rows=1)
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)

Line 1549: ,pa_expenditure_items_all exp

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
1553: AND pbc.document_type = 'AP'

Line 7629: pa_expenditure_items_all ei

7625: pa_projects_all pp,
7626: pa_budget_versions bv,
7627: pa_budget_entry_methods pm,
7628: pa_expenditure_types type,
7629: pa_expenditure_items_all ei
7630: WHERE pbc.packet_id = p_packet_id
7631: AND pp.project_id = pbc.project_id
7632: AND bv.project_id = pp.project_id
7633: AND pbc.budget_version_id = bv.budget_version_id

Line 7731: pa_expenditure_items_all item

7727: CURSOR get_exp_details(v_doc_header_id NUMBER) IS
7728: SELECT EXP.incurred_by_person_id,
7729: item.job_id
7730: FROM pa_expenditures_all exp,
7731: pa_expenditure_items_all item
7732: WHERE item.expenditure_item_id = v_doc_header_id
7733: AND item.expenditure_id = EXP.expenditure_id;
7734:
7735: CURSOR get_non_usg_exp_details(v_doc_exp_type VARCHAR2) IS

Line 7747: pa_expenditure_items_all item

7743: item.job_id,
7744: item.non_labor_resource,
7745: item.organization_id
7746: FROM pa_expenditures_all exp,
7747: pa_expenditure_items_all item
7748: WHERE item.expenditure_item_id = v_doc_header_id
7749: AND item.expenditure_id = EXP.expenditure_id;
7750:
7751: CURSOR cur_resList IS

Line 10278: UPDATE pa_expenditure_items_all

10274: | Bug 3565708: Added g_tab_p_bc_packet_id(i) = -7777 ; so |
10275: | rejection would include BTC txns also. |
10276: +=========================================================*/
10277: FORALL i IN g_tab_doc_header_id.FIRST .. g_tab_doc_header_id.LAST
10278: UPDATE pa_expenditure_items_all
10279: SET cost_dist_rejection_code =
10280: decode(substr(g_tab_result_code(i),1,1),'F',
10281: g_tab_result_code(i),null)
10282: ,cost_dist_warning_code = l_tab_warning_code(i)