eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TASK_PUB1 dependencies on PJI_XBS_PLANS_V

Line 13794: from pji_xbs_plans_v

13790:
13791: cursor cur_prev_planned_task_effort(p_project_id NUMBER, p_proj_element_id NUMBER
13792: , p_structure_version_id NUMBER) is
13793: select (labor_effort+equipment_effort)
13794: from pji_xbs_plans_v
13795: where project_id = p_project_id
13796: and structure_version_id = p_structure_version_id
13797: and proj_element_id = p_proj_element_id
13798: and structure_type = 'WORKPLAN';

Line 13933: from pji_xbs_plans_v

13929:
13930:
13931: cursor cur_get_costs(p_project_id NUMBER, p_object_id NUMBER, p_structure_version_id NUMBER) is
13932: select nvl(BRDN_COST, 0), nvl(ACT_LABOR_BRDN_COST, 0)
13933: from pji_xbs_plans_v
13934: where project_id = p_project_id
13935: and proj_element_id = p_object_id
13936: and structure_version_id = p_structure_version_id;
13937:

Line 13979: from pji_xbs_plans_v

13975:
13976: --BUG 3919800, rtarway
13977: cursor cur_get_act_effort (p_project_id NUMBER, p_object_id NUMBER, p_structure_version_id NUMBER) is
13978: select nvl(ACT_LABOR_HRS, 0)+nvl(ACT_EQUIP_HRS,0)
13979: from pji_xbs_plans_v
13980: where project_id = p_project_id
13981: and proj_element_id = p_object_id
13982: and structure_version_id = p_structure_version_id ;
13983: