DBA Data[Home] [Help]

APPS.PA_PROGRESS_PUB dependencies on PJI_XBS_PLANS_V

Line 11932: FROM pji_xbs_plans_v

11928:
11929: CURSOR cur_task_plan (c_proj_element_id NUMBER)
11930: IS
11931: SELECT labor_effort
11932: FROM pji_xbs_plans_v
11933: WHERE project_id = p_project_id
11934: AND proj_element_id = c_proj_element_id
11935: AND STRUCTURE_VERSION_ID = p_pub_structure_version_id
11936: AND STRUCTURE_TYPE = 'WORKPLAN'

Line 11944: FROM pji_xbs_plans_v

11940: --bug 4191360, start
11941: /*CURSOR cur_task_plan_cost (c_proj_element_id NUMBER)
11942: IS
11943: SELECT nvl(BRDN_COST, 0)
11944: FROM pji_xbs_plans_v
11945: WHERE project_id = p_project_id
11946: AND proj_element_id = c_proj_element_id
11947: AND STRUCTURE_VERSION_ID = p_pub_structure_version_id
11948: AND STRUCTURE_TYPE = 'WORKPLAN'

Line 14234: from pji_xbs_plans_v

14230:
14231: -- cursor to get planned value for task
14232: cursor get_planned_val_for_task is
14233: select labor_effort, labor_brdn_cost
14234: from pji_xbs_plans_v
14235: where project_id = l_project_id
14236: and structure_version_id = l_latest_wp_struct_ver_id
14237: and proj_element_id = l_object_id
14238: and structure_type = 'WORKPLAN';