APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PA_COST_DISTRIBUTION_LINES

Line 8020: FROM PA_Cost_Distribution_Lines CDL,

8016: cdl.budget_version_id,
8017: ITEM.document_line_number,
8018: ITEM.transaction_source,
8019: cdl.rowid
8020: FROM PA_Cost_Distribution_Lines CDL,
8021: pa_expenditure_items_all ITEM,
8022: pa_expenditures_all EXP
8023: WHERE CDL.transfer_status_code in ('A', 'G')
8024: AND CDL.request_id = p_request_id

Line 8339: UPDATE pa_cost_distribution_lines_all cdl

8335: pa_funds_control_pkg.log_message(p_msg_token1 => 'INTERFACE_TBC_BTC_COMT_UPDATE : derived budget line id on cdl'||l_budget_line_id);
8336: End if;
8337: END IF;
8338:
8339: UPDATE pa_cost_distribution_lines_all cdl
8340: SET cdl.budget_version_id = NVL(l_cdl_budget_version_id,l_bc_budget_version_id_tbl(1)),
8341: cdl.budget_line_id = l_budget_line_id
8342: WHERE cdl.rowid = l_cdl_rowid_tbl(cdl_rec);
8343:

Line 8377: FROM PA_Cost_Distribution_lines cdl_raw,

8373: bc_cm.liquidate_gl_date = l_cdl_gl_Date_tbl(i),
8374: 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
8375: WHERE ( bc_cm.document_header_id,bc_cm.document_distribution_id,expenditure_type)
8376: IN ( SELECT exp.document_header_id,exp.document_distribution_id,l_expenditure_type_tbl(i)
8377: FROM PA_Cost_Distribution_lines cdl_raw,
8378: pa_expenditure_items_all exp ,
8379: pa_expenditures_all expend
8380: WHERE cdl_raw.burden_sum_source_run_id = l_Burd_Sum_Dest_Run_Id_tbl(i)
8381: AND exp.expenditure_item_id = cdl_raw.expenditure_item_id

Line 8487: FROM PA_Cost_Distribution_lines cdl_raw,

8483: FROM pa_expenditure_items_all peia
8484: WHERE peia.TRANSFERRED_FROM_EXP_ITEM_ID IS NULL
8485: START WITH peia.expenditure_item_id in (
8486: SELECT cdl_raw.expenditure_item_id
8487: FROM PA_Cost_Distribution_lines cdl_raw,
8488: Pa_Expenditure_Items ei_raw,
8489: pa_expenditures_all expend
8490: WHERE cdl_raw.burden_sum_source_run_id = l_Burd_Sum_Dest_Run_Id_tbl(i)
8491: AND cdl_raw.line_num = 1