DBA Data[Home] [Help]

APPS.PA_UTILS3 dependencies on PA_EXPENDITURE_ITEMS

Line 457: FROM pa_expenditure_items ei

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

Line 472: FROM pa_expenditure_items ei

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