APPS.PA_COST_PLUS dependencies on PA_COST_DISTRIBUTION_LINES

Line 6047: AND exists ( select 1 from pa_cost_distribution_lines_all cdl

6043: UPDATE pa_expenditure_items_all ITEM
6044: SET ITEM.adjustment_type = decode(ITEM.cost_ind_compiled_set_id, compiled_set_id, 'BURDEN_RESUMMARIZE' ,ITEM.adjustment_type)
6045: WHERE ITEM.cost_distributed_flag ='Y'
6046: AND ITEM.adjustment_type IS NULL
6047: AND exists ( select 1 from pa_cost_distribution_lines_all cdl
6048: where cdl.burden_sum_source_run_id >0
6049: AND cdl.expenditure_item_id =ITEM.expenditure_item_id
6050: AND cdl.line_type ='R'
6051: AND nvl(cdl.reversed_flag,'N') ='N'

Line 6075: AND exists ( select 1 from pa_cost_distribution_lines_all cdl

6071: UPDATE pa_expenditure_items_all ITEM
6072: SET ITEM.adjustment_type = decode(ITEM.cost_ind_compiled_set_id, compiled_set_id, 'BURDEN_RESUMMARIZE' ,ITEM.adjustment_type)
6073: WHERE ITEM.cost_distributed_flag ='Y'
6074: AND ITEM.adjustment_type IS NULL
6075: AND exists ( select 1 from pa_cost_distribution_lines_all cdl
6076: where cdl.burden_sum_source_run_id >0
6077: AND cdl.expenditure_item_id =ITEM.expenditure_item_id
6078: AND cdl.line_type ='R'
6079: AND nvl(cdl.reversed_flag,'N') ='N'

Line 6516: AND exists ( select 1 from pa_cost_distribution_lines_all cdl

6512: UPDATE pa_expenditure_items_all ITEM
6513: SET ITEM.adjustment_type = decode(ITEM.cost_ind_compiled_set_id, compiled_set_id, 'BURDEN_RESUMMARIZE' ,ITEM.adjustment_type)
6514: WHERE ITEM.cost_distributed_flag ='Y'
6515: AND ITEM.adjustment_type IS NULL
6516: AND exists ( select 1 from pa_cost_distribution_lines_all cdl
6517: where cdl.burden_sum_source_run_id >0
6518: AND cdl.expenditure_item_id =ITEM.expenditure_item_id
6519: AND cdl.line_type ='R'
6520: AND nvl(cdl.reversed_flag,'N') ='N'

Line 7862: FROM pa_cost_distribution_lines cdl

7858: g_request_id := p_request_id;
7859: x_return_status := 0;
7860: l_stage := 100;
7861: DELETE
7862: FROM pa_cost_distribution_lines cdl
7863: WHERE cdl.line_type IN ('C', 'D')
7864: AND cdl.request_id = g_request_id
7865: AND cdl.expenditure_item_id in (Select
7866: ei.expenditure_item_id from pa_expenditure_items ei