APPS.PA_PROJ_ELEMENTS_UTILS dependencies on PA_PROJECT_STATUSES

Line 2718: from pa_proj_elements a, pa_project_statuses b

2714: IS
2715: --bug 2863836: modified cursor to refer to system status
2716: cursor c1 is
2717: select b.project_system_status_code
2718: from pa_proj_elements a, pa_project_statuses b
2719: where a.proj_element_id = p_task_id
2720: and a.status_code = b.project_status_code
2721: and b.status_type = 'TASK';
2722: l_dummy pa_proj_elements.status_code%TYPE;

Line 2909: from pa_project_statuses pps,

2905: )
2906: IS
2907: CURSOR get_status IS
2908: select ppe.project_id, ppe.proj_element_id
2909: from pa_project_statuses pps,
2910: pa_proj_elements ppe,
2911: pa_proj_element_versions ppev
2912: where ppev.element_version_id = p_parent_task_ver_id
2913: and ppe.project_id = ppev.project_id

Line 3304: from pa_project_statuses pps,

3300: )
3301: IS
3302: CURSOR get_status IS
3303: select '1'
3304: from pa_project_statuses pps,
3305: pa_proj_elements ppe,
3306: pa_proj_element_versions ppev
3307: where ppev.element_version_id = p_task_ver_id
3308: and ppe.project_id = ppev.project_id

Line 3565: from pa_project_statuses

3561: IS
3562: l_task_stat_sys_code VARCHAR2(30);
3563: BEGIN
3564: select project_system_status_code into l_task_stat_sys_code
3565: from pa_project_statuses
3566: where p_task_status_code = project_status_code
3567: and status_type = 'TASK';
3568:
3569: return l_task_stat_sys_code;