3039: 'SOURCE PURGED',
3040: 'PURGE PROCESS',
3041: g_user,
3042: l_request_id
3043: from pa_tasks t,pa_expenditure_items_all ei
3044: where ei.transferred_from_exp_item_id in ( select ei1.expenditure_item_id
3045: from pa_expenditure_items_all ei1,
3046: pa_tasks t1
3047: where ei1.task_id = t1.task_id
3042: l_request_id
3043: from pa_tasks t,pa_expenditure_items_all ei
3044: where ei.transferred_from_exp_item_id in ( select ei1.expenditure_item_id
3045: from pa_expenditure_items_all ei1,
3046: pa_tasks t1
3047: where ei1.task_id = t1.task_id
3048: and t1.project_id = p_project_id )
3049: and ei.task_id = t.task_id
3050: and ei.transferred_from_exp_item_id is not null