APPS.PA_TASK_ASSIGNMENT_UTILS dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 1295: l_published_flag pa_proj_elem_ver_structure.latest_eff_published_flag%TYPE;

1291: l_task_sch_start DATE;
1292: l_task_sch_end DATE;
1293: l_task_number VARCHAR2(240);
1294: l_task_name VARCHAR2(240);
1295: l_published_flag pa_proj_elem_ver_structure.latest_eff_published_flag%TYPE;
1296: l_return_status VARCHAR2(1);
1297: x_msg_data VARCHAR2(4000);
1298: x_msg_count NUMBER;
1299: l_wbs_element_version_id NUMBER;

Line 1331: FROM pa_proj_elem_ver_structure pevs, pa_proj_element_versions pev

1327: AND pev.proj_element_id = pe.proj_element_id;
1328:
1329: CURSOR C2_Published_Flag(p_elem_version_id IN NUMBER) IS
1330: SELECT latest_eff_published_flag
1331: FROM pa_proj_elem_ver_structure pevs, pa_proj_element_versions pev
1332: WHERE pev.element_version_id = p_elem_version_id
1333: AND pev.parent_structure_version_id = pevs.element_version_id
1334: AND pev.project_id = pevs.project_id;
1335:

Line 6325: pa_proj_elem_ver_structure ppevs,

6321: FROM dual
6322: WHERE EXISTS
6323: (SELECT ppev.element_version_id
6324: FROM pa_proj_element_versions ppev,
6325: pa_proj_elem_ver_structure ppevs,
6326: pa_proj_structure_types ppst
6327: WHERE
6328: ppev.element_version_id = l_str_ver_id
6329: and ppev.project_id = l_project_id