DBA Data[Home] [Help]

APPS.PA_PURGE_COSTING dependencies on PA_TASKS

Line 3043: from pa_tasks t,pa_expenditure_items_all ei

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

Line 3046: pa_tasks t1

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