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 2239: from pa_proj_elem_ver_schedule sch,

2235: RETURN NUMBER
2236: IS
2237: CURSOR c1 IS
2238: select scheduled_start_date
2239: from pa_proj_elem_ver_schedule sch,
2240: pa_proj_element_versions ev
2241: where p_element_version_id = ev.element_version_id
2242: and ev.element_version_id = sch.element_version_id
2243: and ev.project_id = sch.project_id;

Line 2265: from pa_proj_elem_ver_schedule sch,

2261: RETURN NUMBER
2262: IS
2263: CURSOR c1 IS
2264: select scheduled_finish_date
2265: from pa_proj_elem_ver_schedule sch,
2266: pa_proj_element_versions ev
2267: where p_element_version_id = ev.element_version_id
2268: and ev.element_version_id = sch.element_version_id
2269: and ev.project_id = sch.project_id;

Line 2291: from pa_proj_elem_ver_schedule sch,

2287: RETURN DATE
2288: IS
2289: CURSOR c1(c_project_id NUMBER, c_structure_version_id NUMBER) IS
2290: select sch.scheduled_start_date
2291: from pa_proj_elem_ver_schedule sch,
2292: pa_proj_element_versions pev,
2293: pa_proj_element_versions pev2
2294: where pev.project_id = c_project_id
2295: and pev.parent_structure_version_id = c_structure_version_id

Line 2337: from pa_proj_elem_ver_schedule sch,

2333: RETURN DATE
2334: IS
2335: CURSOR c1(c_project_id NUMBER, c_structure_version_id NUMBER) IS
2336: select sch.scheduled_finish_date
2337: from pa_proj_elem_ver_schedule sch,
2338: pa_proj_element_versions pev,
2339: pa_proj_element_versions pev2
2340: where pev.project_id = c_project_id
2341: and pev.parent_structure_version_id = c_structure_version_id

Line 2835: from pa_proj_elem_ver_schedule ppvsch,

2831: where ppev.element_version_id = p_parent_task_ver_id;
2832:
2833: CURSOR get_schedule_info IS
2834: select 1
2835: from pa_proj_elem_ver_schedule ppvsch,
2836: pa_proj_element_versions ppev
2837: where ppev.element_version_id = p_parent_task_ver_id
2838: and ppev.project_id = ppvsch.project_id
2839: and ppev.proj_element_id = ppvsch.proj_element_id