APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_EXPENDITURE_ITEMS_ALL

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

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

Line 1542: ,pa_expenditure_items_all exp

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

Line 7431: pa_expenditure_items_all ei

7427: pa_projects_all pp,
7428: pa_budget_versions bv,
7429: pa_budget_entry_methods pm,
7430: pa_expenditure_types type,
7431: pa_expenditure_items_all ei
7432: WHERE pbc.packet_id = p_packet_id
7433: AND pp.project_id = pbc.project_id
7434: AND bv.project_id = pp.project_id
7435: AND pbc.budget_version_id = bv.budget_version_id

Line 7533: pa_expenditure_items_all item

7529: CURSOR get_exp_details(v_doc_header_id NUMBER) IS
7530: SELECT EXP.incurred_by_person_id,
7531: item.job_id
7532: FROM pa_expenditures_all exp,
7533: pa_expenditure_items_all item
7534: WHERE item.expenditure_item_id = v_doc_header_id
7535: AND item.expenditure_id = EXP.expenditure_id;
7536:
7537: CURSOR get_non_usg_exp_details(v_doc_exp_type VARCHAR2) IS

Line 7549: pa_expenditure_items_all item

7545: item.job_id,
7546: item.non_labor_resource,
7547: item.organization_id
7548: FROM pa_expenditures_all exp,
7549: pa_expenditure_items_all item
7550: WHERE item.expenditure_item_id = v_doc_header_id
7551: AND item.expenditure_id = EXP.expenditure_id;
7552:
7553: CURSOR cur_resList IS

Line 10021: UPDATE pa_expenditure_items_all

10017: | Bug 3565708: Added g_tab_p_bc_packet_id(i) = -7777 ; so |
10018: | rejection would include BTC txns also. |
10019: +=========================================================*/
10020: FORALL i IN g_tab_doc_header_id.FIRST .. g_tab_doc_header_id.LAST
10021: UPDATE pa_expenditure_items_all
10022: SET cost_dist_rejection_code =
10023: decode(substr(g_tab_result_code(i),1,1),'F',
10024: g_tab_result_code(i),null)
10025: ,cost_dist_warning_code = l_tab_warning_code(i)