APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 8395: pa_expenditure_items_all ITEM,

8391: ITEM.document_line_number,
8392: ITEM.transaction_source,
8393: cdl.rowid
8394: FROM PA_Cost_Distribution_Lines CDL,
8395: pa_expenditure_items_all ITEM,
8396: pa_expenditures_all EXP
8397: WHERE CDL.transfer_status_code in ('A', 'G')
8398: AND CDL.request_id = p_request_id
8399: AND item.expenditure_item_id = cdl.expenditure_item_id

Line 8759: pa_expenditure_items_all exp ,

8755: bc_cm.exp_item_id = DECODE (l_cdl_line_type_tbl(i),'R',l_Exp_Item_Id_tbl(i),bc_cm.exp_item_id) -- Bug 5076612
8756: WHERE ( bc_cm.document_header_id,bc_cm.document_distribution_id,expenditure_type)
8757: IN ( SELECT exp.document_header_id,exp.document_distribution_id,l_expenditure_type_tbl(i)
8758: FROM PA_Cost_Distribution_lines cdl_raw,
8759: pa_expenditure_items_all exp ,
8760: pa_expenditures_all expend
8761: WHERE cdl_raw.burden_sum_source_run_id = l_Burd_Sum_Dest_Run_Id_tbl(i)
8762: AND exp.expenditure_item_id = cdl_raw.expenditure_item_id
8763: AND cdl_raw.line_num = 1

Line 8864: FROM pa_expenditure_items_all peia

8860: bc_cm.liquidate_gl_date = l_cdl_gl_Date_tbl(i),
8861: bc_cm.exp_item_id = DECODE (l_cdl_line_type_tbl(i),'R',l_Exp_Item_Id_tbl(i),bc_cm.exp_item_id)-- Bug 5076612
8862: WHERE (bc_cm.exp_item_id,bc_cm.expenditure_type)
8863: IN ( SELECT peia.expenditure_item_id ,l_expenditure_type_tbl(i) -- Bug 5663343 : Handled transfer/split cases
8864: FROM pa_expenditure_items_all peia
8865: WHERE peia.TRANSFERRED_FROM_EXP_ITEM_ID IS NULL
8866: START WITH peia.expenditure_item_id in (
8867: SELECT cdl_raw.expenditure_item_id
8868: FROM PA_Cost_Distribution_lines cdl_raw,