APPS.PA_PROJECT_STRUCTURE_UTILS dependencies on PA_PROJECT_STATUSES

Line 2979: from pa_project_statuses pps,

2975: l_element_version_id NUMBER;
2976:
2977: CURSOR c2(c_proj_element_id NUMBER) IS
2978: select pps.project_system_status_code
2979: from pa_project_statuses pps,
2980: pa_proj_elements ppe
2981: where ppe.proj_element_id = c_proj_element_id
2982: and ppe.status_code = pps.project_status_code
2983: and pps.status_type = 'TASK'

Line 2988: from pa_project_statuses pps,

2984: and pps.project_system_status_code = 'CANCELLED';
2985:
2986: CURSOR c3(c_parent_task_ver_id NUMBER) IS
2987: select pps.project_system_status_code
2988: from pa_project_statuses pps,
2989: pa_proj_elements ppe,
2990: pa_proj_element_versions ppev,
2991: pa_object_relationships por
2992: where por.object_id_from1 = c_parent_task_ver_id

Line 3004: l_system_status_code pa_project_statuses.project_system_status_code%TYPE;

3000: and ppe.status_code = pps.project_status_code
3001: and pps.status_type = 'TASK'
3002: and pps.project_system_status_code NOT IN ('CANCELLED','COMPLETED')
3003: and ppev.TASK_UNPUB_VER_STATUS_CODE = 'TO_BE_DELETED';
3004: l_system_status_code pa_project_statuses.project_system_status_code%TYPE;
3005:
3006: CURSOR get_task_name_num(c_proj_element_id NUMBER) IS
3007: select name, element_number
3008: from pa_proj_elements