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_PROJ_ELEMENTS_UTILS dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 371: --pa_proj_elem_ver_structure and pa_proj_elem_ver_schedule

367: --table.The above cursor is though needed when the structure
368: --version infirmation such as description is updated.
369:
370: --Now after the fix ,both the maximum dates from
371: --pa_proj_elem_ver_structure and pa_proj_elem_ver_schedule
372: --are compared.The structure version info corresponding
373: --to greater last_updated_date is returned.
374:
375: CURSOR cur_elem_ver_stru2

Line 383: pa_proj_elem_ver_schedule a,

379: c.element_version_id,
380: c.name,
381: c.record_version_number
382: FROM pa_proj_element_versions b,
383: pa_proj_elem_ver_schedule a,
384: pa_proj_elem_ver_structure c,
385: pa_structure_types d ,
386: pa_proj_structure_types e
387: WHERE a.element_version_id= b.element_version_id

Line 2332: from pa_proj_elem_ver_schedule sch,

2328: RETURN NUMBER
2329: IS
2330: CURSOR c1 IS
2331: select scheduled_start_date
2332: from pa_proj_elem_ver_schedule sch,
2333: pa_proj_element_versions ev
2334: where p_element_version_id = ev.element_version_id
2335: and ev.element_version_id = sch.element_version_id
2336: and ev.project_id = sch.project_id;

Line 2358: from pa_proj_elem_ver_schedule sch,

2354: RETURN NUMBER
2355: IS
2356: CURSOR c1 IS
2357: select scheduled_finish_date
2358: from pa_proj_elem_ver_schedule sch,
2359: pa_proj_element_versions ev
2360: where p_element_version_id = ev.element_version_id
2361: and ev.element_version_id = sch.element_version_id
2362: and ev.project_id = sch.project_id;

Line 2384: from pa_proj_elem_ver_schedule sch,

2380: RETURN DATE
2381: IS
2382: CURSOR c1(c_project_id NUMBER, c_structure_version_id NUMBER) IS
2383: select sch.scheduled_start_date
2384: from pa_proj_elem_ver_schedule sch,
2385: pa_proj_element_versions pev,
2386: pa_proj_element_versions pev2
2387: where pev.project_id = c_project_id
2388: and pev.parent_structure_version_id = c_structure_version_id

Line 2430: from pa_proj_elem_ver_schedule sch,

2426: RETURN DATE
2427: IS
2428: CURSOR c1(c_project_id NUMBER, c_structure_version_id NUMBER) IS
2429: select sch.scheduled_finish_date
2430: from pa_proj_elem_ver_schedule sch,
2431: pa_proj_element_versions pev,
2432: pa_proj_element_versions pev2
2433: where pev.project_id = c_project_id
2434: and pev.parent_structure_version_id = c_structure_version_id

Line 2928: from pa_proj_elem_ver_schedule ppvsch,

2924: where ppev.element_version_id = p_parent_task_ver_id;
2925:
2926: CURSOR get_schedule_info IS
2927: select 1
2928: from pa_proj_elem_ver_schedule ppvsch,
2929: pa_proj_element_versions ppev
2930: where ppev.element_version_id = p_parent_task_ver_id
2931: and ppev.project_id = ppvsch.project_id
2932: and ppev.proj_element_id = ppvsch.proj_element_id