APPS.PA_COST_PLUS dependencies on PA_COST_DISTRIBUTION_LINES_ALL

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'