DBA Data[Home] [Help]

APPS.PA_TASK_PUB1 dependencies on PJI_XBS_PLANS_V

Line 13270: from pji_xbs_plans_v

13266:
13267: cursor cur_prev_planned_task_effort(p_project_id NUMBER, p_proj_element_id NUMBER
13268: , p_structure_version_id NUMBER) is
13269: select (labor_effort+equipment_effort)
13270: from pji_xbs_plans_v
13271: where project_id = p_project_id
13272: and structure_version_id = p_structure_version_id
13273: and proj_element_id = p_proj_element_id
13274: and structure_type = 'WORKPLAN';

Line 13409: from pji_xbs_plans_v

13405:
13406:
13407: cursor cur_get_costs(p_project_id NUMBER, p_object_id NUMBER, p_structure_version_id NUMBER) is
13408: select nvl(BRDN_COST, 0), nvl(ACT_LABOR_BRDN_COST, 0)
13409: from pji_xbs_plans_v
13410: where project_id = p_project_id
13411: and proj_element_id = p_object_id
13412: and structure_version_id = p_structure_version_id;
13413:

Line 13455: from pji_xbs_plans_v

13451:
13452: --BUG 3919800, rtarway
13453: cursor cur_get_act_effort (p_project_id NUMBER, p_object_id NUMBER, p_structure_version_id NUMBER) is
13454: select nvl(ACT_LABOR_HRS, 0)+nvl(ACT_EQUIP_HRS,0)
13455: from pji_xbs_plans_v
13456: where project_id = p_project_id
13457: and proj_element_id = p_object_id
13458: and structure_version_id = p_structure_version_id ;
13459: