DBA Data[Home] [Help]

APPS.PA_UTILS3 dependencies on PA_EXPENDITURE_ITEMS

Line 455: FROM pa_expenditure_items ei

451: -- Transferred from project and Task Details.
452: BEGIN
453: SELECT proj.segment1||'/'||TASK.task_number
454: INTO l_proj_task_info
455: FROM pa_expenditure_items ei
456: ,pa_projects_all proj
457: ,pa_tasks task
458: WHERE ei.expenditure_item_id = P_Transferred_from_exp_id
459: AND ei.task_id = task.task_id

Line 470: FROM pa_expenditure_items ei

466: -- Transferred To project and Task Details.
467: BEGIN
468: SELECT proj.segment1||'/'||TASK.task_number
469: INTO l_proj_task_info
470: FROM pa_expenditure_items ei
471: ,pa_projects_all proj
472: ,pa_tasks task
473: WHERE ei.transferred_from_exp_item_id = P_exp_item_id
474: AND ei.task_id = task.task_id