APPS.PA_TASK_ASSIGNMENT_UTILS dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 1403: l_published_flag pa_proj_elem_ver_structure.latest_eff_published_flag%TYPE;

1399: l_task_sch_start DATE;
1400: l_task_sch_end DATE;
1401: l_task_number VARCHAR2(240);
1402: l_task_name VARCHAR2(240);
1403: l_published_flag pa_proj_elem_ver_structure.latest_eff_published_flag%TYPE;
1404: l_return_status VARCHAR2(1);
1405: x_msg_data VARCHAR2(4000);
1406: x_msg_count NUMBER;
1407: l_wbs_element_version_id NUMBER;

Line 1439: FROM pa_proj_elem_ver_structure pevs, pa_proj_element_versions pev

1435: AND pev.proj_element_id = pe.proj_element_id;
1436:
1437: CURSOR C2_Published_Flag(p_elem_version_id IN NUMBER) IS
1438: SELECT latest_eff_published_flag
1439: FROM pa_proj_elem_ver_structure pevs, pa_proj_element_versions pev
1440: WHERE pev.element_version_id = p_elem_version_id
1441: AND pev.parent_structure_version_id = pevs.element_version_id
1442: AND pev.project_id = pevs.project_id;
1443:

Line 6450: pa_proj_elem_ver_structure ppevs,

6446: FROM dual
6447: WHERE EXISTS
6448: (SELECT ppev.element_version_id
6449: FROM pa_proj_element_versions ppev,
6450: pa_proj_elem_ver_structure ppevs,
6451: pa_proj_structure_types ppst
6452: WHERE
6453: ppev.element_version_id = l_str_ver_id
6454: and ppev.project_id = l_project_id