APPS.PA_PROJ_ELEMENTS_UTILS dependencies on PA_PROJECT_STATUSES

Line 2625: from pa_proj_elements a, pa_project_statuses b

2621: IS
2622: --bug 2863836: modified cursor to refer to system status
2623: cursor c1 is
2624: select b.project_system_status_code
2625: from pa_proj_elements a, pa_project_statuses b
2626: where a.proj_element_id = p_task_id
2627: and a.status_code = b.project_status_code
2628: and b.status_type = 'TASK';
2629: l_dummy pa_proj_elements.status_code%TYPE;

Line 2816: from pa_project_statuses pps,

2812: )
2813: IS
2814: CURSOR get_status IS
2815: select ppe.project_id, ppe.proj_element_id
2816: from pa_project_statuses pps,
2817: pa_proj_elements ppe,
2818: pa_proj_element_versions ppev
2819: where ppev.element_version_id = p_parent_task_ver_id
2820: and ppe.project_id = ppev.project_id

Line 3211: from pa_project_statuses pps,

3207: )
3208: IS
3209: CURSOR get_status IS
3210: select '1'
3211: from pa_project_statuses pps,
3212: pa_proj_elements ppe,
3213: pa_proj_element_versions ppev
3214: where ppev.element_version_id = p_task_ver_id
3215: and ppe.project_id = ppev.project_id

Line 3472: from pa_project_statuses

3468: IS
3469: l_task_stat_sys_code VARCHAR2(30);
3470: BEGIN
3471: select project_system_status_code into l_task_stat_sys_code
3472: from pa_project_statuses
3473: where p_task_status_code = project_status_code
3474: and status_type = 'TASK';
3475:
3476: return l_task_stat_sys_code;