APPS.PA_PROGRESS_REPORT_UTILS dependencies on PA_TASKS

Line 436: SELECT project_id FROM pa_tasks

432: l_project_id NUMBER;
433: l_task_id NUMBER;
434:
435: CURSOR get_project_id IS
436: SELECT project_id FROM pa_tasks
437: WHERE task_id = l_task_id;
438: BEGIN
439:
440: -- Initialize the Error Stack

Line 708: and ppe.object_type = 'PA_TASKS';

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
711: select ptt.task_progress_entry_page_id
712: from pa_proj_elements ppe,

Line 716: and ppe.object_type = 'PA_TASKS';

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:
718: BEGIN
719:
720: