APPS.PA_TASK_PVT1 dependencies on PA_TASK_TYPES

Line 343: from pa_task_types

339: select WORK_ITEM_CODE, UOM_CODE,
340: ACTUAL_WQ_ENTRY_CODE, TASK_PROGRESS_ENTRY_PAGE_ID,
341: INITIAL_STATUS_CODE, BASE_PERCENT_COMP_DERIV_CODE,
342: wf_item_type,wf_process,wf_start_lead_days
343: from pa_task_types
344: where task_type_id = c_task_type_id;
345: --l_task_weighting_deriv_code PA_PROJ_ELEMENTS.task_weighting_deriv_code%TYPE;
346: l_work_item_code PA_PROJ_ELEMENTS.wq_item_code%TYPE;
347: l_uom_code PA_PROJ_ELEMENTS.wq_uom_code%TYPE;

Line 1805: from pa_task_types

1801: CURSOR get_task_types_attr(c_task_type_id NUMBER) IS
1802: select WORK_ITEM_CODE, UOM_CODE,
1803: ACTUAL_WQ_ENTRY_CODE, TASK_PROGRESS_ENTRY_PAGE_ID,
1804: prog_entry_enable_flag,BASE_PERCENT_COMP_DERIV_CODE --Jun 28th
1805: from pa_task_types
1806: where task_type_id = c_task_type_id;
1807: get_task_type_attr_rec get_task_types_attr%ROWTYPE;
1808: get_task_type_attr_rec_old get_task_types_attr%ROWTYPE;
1809:

Line 4174: FROM pa_task_types ptt,

4170: --bug 2673570
4171: CURSOR check_progress_allowed(c_element_version_id NUMBER)
4172: IS
4173: SELECT ptt.prog_entry_enable_flag
4174: FROM pa_task_types ptt,
4175: pa_proj_element_versions ppev,
4176: pa_proj_elements ppe
4177: WHERE ppev.element_version_id = c_element_version_id
4178: AND ppev.proj_element_id = ppe.proj_element_id

Line 9352: FROM pa_task_types ptt,

9348: --bug 2673570
9349: CURSOR check_progress_allowed(c_element_version_id NUMBER)
9350: IS
9351: SELECT ptt.prog_entry_enable_flag
9352: FROM pa_task_types ptt,
9353: pa_proj_element_versions ppev,
9354: pa_proj_elements ppe
9355: WHERE ppev.element_version_id = c_element_version_id
9356: AND ppev.proj_element_id = ppe.proj_element_id

Line 11036: pa_task_types ptt

11032: FROM pa_proj_element_versions ppev,
11033: pa_object_relationships por,
11034: pa_proj_elem_ver_schedule ppevs,
11035: pa_proj_elements ppe,
11036: pa_task_types ptt
11037: WHERE ppev.parent_structure_version_id = c_parent_struc_ver_id -- 377522
11038: AND por.object_type_to = 'PA_TASKS'
11039: AND por.relationship_type = 'S'
11040: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')