APPS.PA_TASK_TYPE_UTILS dependencies on PA_TASK_TYPES

Line 11: FROM pa_task_types

7: l_task_type_unique VARCHAR2(1);
8:
9: CURSOR c1 IS
10: SELECT 'X'
11: FROM pa_task_types
12: WHERE task_type = p_task_type
13: AND object_type = 'PA_TASKS' /* bug 3279978 FP M Enhancement */
14: AND ((task_type_id <> p_task_type_id AND p_task_type_id IS NOT NULL)
15: OR p_task_type_id IS NULL);

Line 48: FROM pa_task_types

44:
45: IS
46: CURSOR c1(p_task_type_id IN NUMBER) IS
47: SELECT prog_entry_enable_flag, wq_enable_flag, percent_comp_enable_flag, remain_effort_enable_flag
48: FROM pa_task_types
49: WHERE task_type_id = p_task_type_id;
50:
51: CURSOR c2(p_task_type_id IN NUMBER) IS
52: SELECT prog_entry_enable_flag, wq_enable_flag, percent_comp_enable_flag, remain_effort_enable_flag

Line 53: FROM pa_task_types

49: WHERE task_type_id = p_task_type_id;
50:
51: CURSOR c2(p_task_type_id IN NUMBER) IS
52: SELECT prog_entry_enable_flag, wq_enable_flag, percent_comp_enable_flag, remain_effort_enable_flag
53: FROM pa_task_types
54: WHERE task_type_id = p_task_type_id;
55:
56: v_c1 c1%ROWTYPE;
57: v_c2 c2%ROWTYPE;

Line 273: Select 'X' from pa_task_types

269: p_page_id NUMBER ) RETURN BOOLEAN
270: is
271: Cursor c_task_type_ref
272: is
273: Select 'X' from pa_task_types
274: where task_progress_entry_page_id = p_page_id
275: AND object_type = 'PA_TASKS'; /* bug 3279978 FP M Enhancement */
276:
277: l_dummy varchar2(1);

Line 535: from pa_task_types

531: RETURN VARCHAR2
532: IS
533: CURSOR c1 IS
534: select 'Y'
535: from pa_task_types
536: where task_type_id = p_task_type_id
537: and sysdate > start_date_active
538: and (end_date_active IS NULL or end_date_active > sysdate);
539: l_dummy VARCHAR2(1);

Line 555: from pa_task_types

551: RETURN VARCHAR2
552: IS
553: CURSOR c1 IS
554: select 'Y'
555: from pa_task_types
556: where task_type_id = p_task_type_id
557: and PROG_ENTRY_ENABLE_FLAG = 'Y';
558: l_dummy VARCHAR2(1);
559:

Line 576: from pa_task_types

572: RETURN VARCHAR2
573: IS
574: CURSOR c1 IS
575: select 'Y'
576: from pa_task_types
577: where task_type_id = p_task_type_id
578: and WQ_ENABLE_FLAG = 'Y';
579: l_dummy VARCHAR2(1);
580: BEGIN