APPS.PA_PROGRESS_REPORT_UTILS dependencies on PA_PROJ_ELEMENTS

Line 706: from pa_proj_elements ppe

702: and lookup_code = p_page_type_code;
703:
704: CURSOR get_ai_page_id IS
705: select task_progress_entry_page_id
706: from pa_proj_elements ppe
707: where ppe.proj_element_id = p_object_id
708: and ppe.object_type = 'PA_TASKS';
709:
710: CURSOR task_type_page_id IS

Line 712: from pa_proj_elements ppe,

708: and ppe.object_type = 'PA_TASKS';
709:
710: CURSOR task_type_page_id IS
711: select ptt.task_progress_entry_page_id
712: from pa_proj_elements ppe,
713: pa_task_types ptt
714: where ppe.type_id = ptt.task_type_id
715: and ppe.proj_element_id = p_object_id
716: and ppe.object_type = 'PA_TASKS';

Line 777: get from pa_task_types if it is null in pa_proj_elements. If it is null in

773: ELSIF p_page_type_code = 'AI' THEN
774:
775: /*
776: the query to get page_id for this page type should try to
777: get from pa_task_types if it is null in pa_proj_elements. If it is null in
778: pa_task_types then it should get the default.
779: */
780: open get_ai_page_id;
781: fetch get_ai_page_id into l_page_id;