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.PSP_GENERAL dependencies on PSP_SCHEDULE_HIERARCHY

Line 1336: psp_schedule_hierarchy psh,

1332: IS
1333: CURSOR percent_effort_cur IS
1334: SELECT NVL(SUM(schedule_percent), 0)
1335: FROM per_assignments_f paf,
1336: psp_schedule_hierarchy psh,
1337: psp_schedule_lines psl
1338: WHERE paf.person_id = p_person_id
1339: AND TRUNC(p_effective_date) BETWEEN paf.effective_start_date AND paf.effective_end_date
1340: AND psh.assignment_id = paf.assignment_id

Line 3112: , psp_schedule_hierarchy psh

3108: IS
3109: CURSOR c_element_level IS
3110: SELECT 1
3111: FROM psp_schedule_lines psl
3112: , psp_schedule_hierarchy psh
3113: WHERE psh.scheduling_types_code IN ('ET')
3114: AND psh.schedule_hierarchy_id = psl.schedule_hierarchy_id
3115: AND project_id = nvl (p_project_id, project_id)
3116: AND task_id = nvl (p_task_id, task_id)

Line 3156: , psp_schedule_hierarchy psh

3152: IS
3153: CURSOR c_element_Group_level IS
3154: SELECT 1
3155: FROM psp_schedule_lines psl
3156: , psp_schedule_hierarchy psh
3157: WHERE psh.scheduling_types_code IN ('EG')
3158: AND psh.schedule_hierarchy_id = psl.schedule_hierarchy_id
3159: AND project_id = nvl (p_project_id, project_id)
3160: AND task_id = nvl (p_task_id, task_id)

Line 3199: , psp_schedule_hierarchy psh

3195: IS
3196: CURSOR c_assignment_level IS
3197: SELECT 1
3198: FROM psp_schedule_lines psl
3199: , psp_schedule_hierarchy psh
3200: WHERE psh.scheduling_types_code IN ('A')
3201: AND psh.schedule_hierarchy_id = psl.schedule_hierarchy_id
3202: AND project_id = nvl (p_project_id, project_id)
3203: AND task_id = nvl (p_task_id, task_id)