DBA Data[Home] [Help]

APPS.PA_PROGRESS_PUB dependencies on PJI_XBS_PLANS_V

Line 11480: FROM pji_xbs_plans_v

11476:
11477: CURSOR cur_task_plan (c_proj_element_id NUMBER)
11478: IS
11479: SELECT labor_effort
11480: FROM pji_xbs_plans_v
11481: WHERE project_id = p_project_id
11482: AND proj_element_id = c_proj_element_id
11483: AND STRUCTURE_VERSION_ID = p_pub_structure_version_id
11484: AND STRUCTURE_TYPE = 'WORKPLAN'

Line 11492: FROM pji_xbs_plans_v

11488: --bug 4191360, start
11489: /*CURSOR cur_task_plan_cost (c_proj_element_id NUMBER)
11490: IS
11491: SELECT nvl(BRDN_COST, 0)
11492: FROM pji_xbs_plans_v
11493: WHERE project_id = p_project_id
11494: AND proj_element_id = c_proj_element_id
11495: AND STRUCTURE_VERSION_ID = p_pub_structure_version_id
11496: AND STRUCTURE_TYPE = 'WORKPLAN'

Line 13741: from pji_xbs_plans_v

13737:
13738: -- cursor to get planned value for task
13739: cursor get_planned_val_for_task is
13740: select labor_effort, labor_brdn_cost
13741: from pji_xbs_plans_v
13742: where project_id = l_project_id
13743: and structure_version_id = l_latest_wp_struct_ver_id
13744: and proj_element_id = l_object_id
13745: and structure_type = 'WORKPLAN';