DBA Data[Home] [Help]

APPS.MRP_EXP_WF dependencies on PA_PROJECTS_ALL

Line 1231: pa_projects_all proj

1227: CURSOR TASK_MANAGER_C(p_project_number in varchar2,
1228: p_task_number in varchar2) IS
1229: SELECT tasks.task_manager_person_id
1230: FROM pa_tasks tasks,
1231: pa_projects_all proj
1232: WHERE tasks.task_number = p_task_number
1233: AND tasks.project_id = proj.project_id
1234: AND proj.segment1 = p_project_number;
1235:

Line 1239: pa_projects_all proj

1235:
1236: CURSOR PROJECT_MANAGER_C(p_project_number in varchar2) IS
1237: SELECT ppp.person_id
1238: FROM pa_project_players ppp,
1239: pa_projects_all proj
1240: WHERE ppp.project_role_type = 'PROJECT MANAGER'
1241: AND ppp.project_id = proj.project_id
1242: AND proj.segment1 = p_project_number;
1243: