DBA Data[Home] [Help]

APPS.PA_PURGE_COSTING dependencies on PA_TASKS

Line 3047: from pa_tasks t,pa_expenditure_items_all ei

3043: 'SOURCE PURGED',
3044: 'PURGE PROCESS',
3045: g_user,
3046: l_request_id
3047: from pa_tasks t,pa_expenditure_items_all ei
3048: where ei.transferred_from_exp_item_id in ( select ei1.expenditure_item_id
3049: from pa_expenditure_items_all ei1,
3050: pa_tasks t1
3051: where ei1.task_id = t1.task_id

Line 3050: pa_tasks t1

3046: l_request_id
3047: from pa_tasks t,pa_expenditure_items_all ei
3048: where ei.transferred_from_exp_item_id in ( select ei1.expenditure_item_id
3049: from pa_expenditure_items_all ei1,
3050: pa_tasks t1
3051: where ei1.task_id = t1.task_id
3052: and t1.project_id = p_project_id )
3053: and ei.task_id = t.task_id
3054: and ei.transferred_from_exp_item_id is not null