DBA Data[Home] [Help]

APPS.PA_PROGRESS_REPORT_UTILS dependencies on PA_TASK_TYPES

Line 713: pa_task_types ptt

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';
717:

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;

Line 778: pa_task_types then it should get the default.

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;
782: close get_ai_page_id;