DBA Data[Home] [Help]

APPS.PA_TASK_PVT1 dependencies on PA_TASK_TYPES

Line 337: from pa_task_types

333: select WORK_ITEM_CODE, UOM_CODE,
334: ACTUAL_WQ_ENTRY_CODE, TASK_PROGRESS_ENTRY_PAGE_ID,
335: INITIAL_STATUS_CODE, BASE_PERCENT_COMP_DERIV_CODE,
336: wf_item_type,wf_process,wf_start_lead_days
337: from pa_task_types
338: where task_type_id = c_task_type_id;
339: --l_task_weighting_deriv_code PA_PROJ_ELEMENTS.task_weighting_deriv_code%TYPE;
340: l_work_item_code PA_PROJ_ELEMENTS.wq_item_code%TYPE;
341: l_uom_code PA_PROJ_ELEMENTS.wq_uom_code%TYPE;

Line 1691: from pa_task_types

1687: CURSOR get_task_types_attr(c_task_type_id NUMBER) IS
1688: select WORK_ITEM_CODE, UOM_CODE,
1689: ACTUAL_WQ_ENTRY_CODE, TASK_PROGRESS_ENTRY_PAGE_ID,
1690: prog_entry_enable_flag,BASE_PERCENT_COMP_DERIV_CODE --Jun 28th
1691: from pa_task_types
1692: where task_type_id = c_task_type_id;
1693: get_task_type_attr_rec get_task_types_attr%ROWTYPE;
1694: get_task_type_attr_rec_old get_task_types_attr%ROWTYPE;
1695:

Line 3969: FROM pa_task_types ptt,

3965: --bug 2673570
3966: CURSOR check_progress_allowed(c_element_version_id NUMBER)
3967: IS
3968: SELECT ptt.prog_entry_enable_flag
3969: FROM pa_task_types ptt,
3970: pa_proj_element_versions ppev,
3971: pa_proj_elements ppe
3972: WHERE ppev.element_version_id = c_element_version_id
3973: AND ppev.proj_element_id = ppe.proj_element_id

Line 8606: FROM pa_task_types ptt,

8602: --bug 2673570
8603: CURSOR check_progress_allowed(c_element_version_id NUMBER)
8604: IS
8605: SELECT ptt.prog_entry_enable_flag
8606: FROM pa_task_types ptt,
8607: pa_proj_element_versions ppev,
8608: pa_proj_elements ppe
8609: WHERE ppev.element_version_id = c_element_version_id
8610: AND ppev.proj_element_id = ppe.proj_element_id