eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_TASKS_PUB dependencies on JTF_TASKS_B

Line 154: FROM jtf_tasks_b

150: FUNCTION task_number (p_task_id IN NUMBER)
151: RETURN VARCHAR2 IS
152: CURSOR c_number IS
153: SELECT task_number
154: FROM jtf_tasks_b
155: WHERE task_id = p_task_id;
156: l_task_number jtf_tasks_b.task_number%TYPE;
157: BEGIN
158: OPEN c_number;

Line 156: l_task_number jtf_tasks_b.task_number%TYPE;

152: CURSOR c_number IS
153: SELECT task_number
154: FROM jtf_tasks_b
155: WHERE task_id = p_task_id;
156: l_task_number jtf_tasks_b.task_number%TYPE;
157: BEGIN
158: OPEN c_number;
159: FETCH c_number INTO l_task_number;
160: CLOSE c_number;

Line 392: FROM jtf_tasks_b

388: l_api_name CONSTANT VARCHAR2 (30) := 'IS_TASK_CLOSABLE';
389:
390: CURSOR c_task_details IS
391: SELECT task_status_id
392: FROM jtf_tasks_b
393: WHERE task_id = p_task_id;
394:
395: -- Cursor to get all the Task Assignments for the Task to be closed.
396: CURSOR c_task_assignments IS

Line 404: FROM jtf_task_assignments ta, jtf_tasks_b t, jtf_task_statuses_b ts

400: , NVL (ts.closed_flag, 'N') closed_flag
401: , NVL (ts.cancelled_flag, 'N') cancelled_flag
402: , NVL (ts.completed_flag, 'N') completed_flag
403: , NVL (ts.rejected_flag, 'N') rejected_flag
404: FROM jtf_task_assignments ta, jtf_tasks_b t, jtf_task_statuses_b ts
405: WHERE ta.task_id = t.task_id
406: AND t.task_id = p_task_id
407: AND assignment_status_id = ts.task_status_id;
408:

Line 559: FROM jtf_tasks_b

555: , planned_end_date
556: , planned_effort
557: , address_id
558: , deleted_flag
559: FROM jtf_tasks_b
560: WHERE task_id = p_task_id;
561:
562: l_task_details c_task_details%ROWTYPE;
563: l_schedulable BOOLEAN;

Line 628: FROM jtf_tasks_b t, jtf_task_assignments ta

624: , t.scheduled_end_date
625: , t.task_split_flag
626: , t.task_status_id
627: , ta.resource_id
628: FROM jtf_tasks_b t, jtf_task_assignments ta
629: WHERE ta.task_id = t.task_id AND t.task_id = p_task_id;
630:
631: l_sched_start jtf_tasks_b.scheduled_start_date%TYPE;
632: l_sched_end jtf_tasks_b.scheduled_end_date%TYPE;

Line 631: l_sched_start jtf_tasks_b.scheduled_start_date%TYPE;

627: , ta.resource_id
628: FROM jtf_tasks_b t, jtf_task_assignments ta
629: WHERE ta.task_id = t.task_id AND t.task_id = p_task_id;
630:
631: l_sched_start jtf_tasks_b.scheduled_start_date%TYPE;
632: l_sched_end jtf_tasks_b.scheduled_end_date%TYPE;
633: l_resource_id jtf_task_assignments.resource_id%TYPE;
634: l_split_flag jtf_tasks_b.task_split_flag%TYPE;
635: l_status_id jtf_task_statuses_b.task_status_id%TYPE;

Line 632: l_sched_end jtf_tasks_b.scheduled_end_date%TYPE;

628: FROM jtf_tasks_b t, jtf_task_assignments ta
629: WHERE ta.task_id = t.task_id AND t.task_id = p_task_id;
630:
631: l_sched_start jtf_tasks_b.scheduled_start_date%TYPE;
632: l_sched_end jtf_tasks_b.scheduled_end_date%TYPE;
633: l_resource_id jtf_task_assignments.resource_id%TYPE;
634: l_split_flag jtf_tasks_b.task_split_flag%TYPE;
635: l_status_id jtf_task_statuses_b.task_status_id%TYPE;
636: BEGIN

Line 634: l_split_flag jtf_tasks_b.task_split_flag%TYPE;

630:
631: l_sched_start jtf_tasks_b.scheduled_start_date%TYPE;
632: l_sched_end jtf_tasks_b.scheduled_end_date%TYPE;
633: l_resource_id jtf_task_assignments.resource_id%TYPE;
634: l_split_flag jtf_tasks_b.task_split_flag%TYPE;
635: l_status_id jtf_task_statuses_b.task_status_id%TYPE;
636: BEGIN
637: -- Initialize API return status to success
638: x_return_status := fnd_api.g_ret_sts_success;

Line 687: FROM jtf_tasks_b t

683: AND r.object_id = p_task_id;
684:
685: CURSOR c_esc(b_task_id NUMBER) IS
686: SELECT 1
687: FROM jtf_tasks_b t
688: , jtf_task_statuses_b s
689: WHERE t.task_id = b_task_id
690: AND t.task_type_id = g_esc_task_type_id
691: AND s.task_status_id = t.task_status_id

Line 826: FROM jtf_tasks_b t

822: , ts.schedulable_flag ts_schedulable_flag
823: , ts.assigned_flag
824: , tt.schedule_flag tt_schedule_flag
825: , ta.resource_name
826: FROM jtf_tasks_b t
827: , csf_ct_task_assignments ta
828: , jtf_task_statuses_vl ts
829: , jtf_task_types_b tt
830: WHERE t.ROWID = CHARTOROWID (p_row_id)

Line 1421: FROM jtf_tasks_b t

1417: , t.scheduled_start_date
1418: , t.scheduled_end_date
1419: , t.object_version_number
1420: , t.source_object_type_code
1421: FROM jtf_tasks_b t
1422: , jtf_task_statuses_b ts
1423: WHERE task_id = p_task_id
1424: AND ts.task_status_id = t.task_status_id;
1425:

Line 1738: FROM jtf_tasks_b t,

1734: , t.planned_end_date
1735: , ta.assignment_status_id
1736: , t.task_split_flag
1737: , t.task_number
1738: FROM jtf_tasks_b t,
1739: (SELECT tas.actual_start_date
1740: , tas.actual_end_date
1741: , tas.resource_id
1742: , tas.resource_type_code

Line 1806: from jtf_tasks_b t, hz_party_sites ps

1802: t.location_id,
1803: t.address_id,
1804: t.customer_id,
1805: NVL(t.location_id, ps.location_id) loc_id
1806: from jtf_tasks_b t, hz_party_sites ps
1807: where task_id=p_task_id
1808: AND ps.party_site_id(+) = t.address_id;
1809: l_task_dtls c_task_details%rowtype;
1810:

Line 2349: FROM jtf_tasks_b t

2345: , ta.assignment_status_id
2346: , cac.status trip_status
2347: , ta.resource_id
2348: , ta.resource_type_code
2349: FROM jtf_tasks_b t
2350: , jtf_task_assignments ta
2351: , jtf_task_statuses_b ts
2352: , cac_sr_object_capacity cac
2353: WHERE t.task_id = p_task_id

Line 2380: FROM jtf_tasks_b t

2376: , ta.assignment_status_id
2377: , cac.status trip_status
2378: , ta.resource_id
2379: , ta.resource_type_code
2380: FROM jtf_tasks_b t
2381: , jtf_task_assignments ta
2382: , jtf_task_statuses_b ts
2383: , cac_sr_object_capacity cac
2384: WHERE t.task_id = p_task_id

Line 2612: TYPE task_split_tbl_type IS TABLE OF jtf_tasks_b.task_split_flag%TYPE;

2608:
2609:
2610:
2611: TYPE ref_cursor_type IS REF CURSOR;
2612: TYPE task_split_tbl_type IS TABLE OF jtf_tasks_b.task_split_flag%TYPE;
2613:
2614: -- REF Cursor to form different query based on different conditions.
2615: c_task_list ref_cursor_type;
2616:

Line 2628: FROM jtf_tasks_b t

2624: -- and only those assigned to Resources belonging to the Dispatcher's Territory.
2625: CURSOR c_child_tasks (p_parent_task_id NUMBER) IS
2626: SELECT t.task_id
2627: , cac.status trip_status
2628: FROM jtf_tasks_b t
2629: , jtf_task_assignments ta
2630: , jtf_task_statuses_b ts
2631: , cac_sr_object_capacity cac
2632: WHERE t.parent_task_id = p_parent_task_id

Line 2697: -- TASK_SPLIT_FLAG is queried from JTF_TASKS_B again since the Query might

2693: CLOSE c_query_where_clause;
2694:
2695: -- Frame the Task List Query
2696:
2697: -- TASK_SPLIT_FLAG is queried from JTF_TASKS_B again since the Query might
2698: -- return PARENT_TASK and CHILD_TASK also and because of that DISTINCT might
2699: -- return two rows one beloning to PARENT_TASK and another for CHILD_TASK bcos
2700: -- of TASK_SPLIT_FLAG.
2701:

Line 2704: FROM jtf_tasks_b t1

2700: -- of TASK_SPLIT_FLAG.
2701:
2702: l_query := ' SELECT DISTINCT NVL(csf_dc_task_grid_v.parent_task_id, csf_dc_task_grid_v.task_id) task_id
2703: , (SELECT t1.task_split_flag
2704: FROM jtf_tasks_b t1
2705: WHERE t1.task_id = NVL(csf_dc_task_grid_v.parent_task_id, csf_dc_task_grid_v.task_id)) task_split_flag
2706: FROM csf_dc_task_grid_v
2707: WHERE ' || l_where_clause || ' ORDER BY 1 DESC';
2708:

Line 2743: FROM jtf_tasks_b t

2739: IF not (l_commit_horizon)
2740: THEN
2741: l_query := 'SELECT DISTINCT NVL(t.parent_task_id, t.task_id) task_id
2742: , t.task_split_flag
2743: FROM jtf_tasks_b t
2744: , jtf_task_assignments ta
2745: , jtf_task_statuses_b ts
2746: , (SELECT TO_NUMBER(SUBSTR(column_value
2747: , 1

Line 2777: FROM jtf_tasks_b t

2773: OPEN c_task_list FOR l_query USING p_res_key,p_from_task_id,p_to_task_id,l_start_date;
2774: ELSE
2775: l_query := 'SELECT DISTINCT NVL(t.parent_task_id, t.task_id) task_id
2776: , t.task_split_flag
2777: FROM jtf_tasks_b t
2778: , jtf_task_assignments ta
2779: , jtf_task_statuses_b ts
2780: , (SELECT TO_NUMBER(SUBSTR(column_value
2781: , 1

Line 2820: FROM jtf_tasks_b t

2816: -- sufficient for us to have Child's Task Split Flag alone
2817:
2818: l_query := 'SELECT DISTINCT NVL(t.parent_task_id, t.task_id) task_id
2819: , t.task_split_flag
2820: FROM jtf_tasks_b t
2821: , jtf_task_assignments ta
2822: , jtf_task_statuses_b ts
2823: WHERE ta.resource_id = :1
2824: AND ta.resource_type_code = :2

Line 2846: FROM jtf_tasks_b t

2842: -- There is just one task and its sufficient for us to get the TASK_SPLIT_FLAG
2843: -- of that task.
2844: l_query := 'SELECT NVL(t.parent_task_id, t.task_id) task_id
2845: , task_split_flag
2846: FROM jtf_tasks_b t
2847: WHERE t.task_id = :1';
2848:
2849: OPEN c_task_list FOR l_query USING p_task_id;
2850: ELSIF p_trip_id IS NOT NULL THEN

Line 2855: , jtf_tasks_b t

2851: l_query := 'SELECT NVL(t.parent_task_id, t.task_id) task_id
2852: , task_split_flag
2853: FROM cac_sr_object_capacity cac
2854: , jtf_task_assignments ta
2855: , jtf_tasks_b t
2856: , jtf_task_statuses_b ts
2857: WHERE cac.object_capacity_id = :1
2858: AND ta.resource_id = cac.object_id
2859: AND ta.resource_type_code = cac.object_type

Line 3107: FROM jtf_tasks_b t

3103: , t.scheduled_end_date
3104: , t.planned_start_date
3105: , t.planned_end_date
3106: , csf_util_pvt.convert_to_minutes(t.actual_effort, t.actual_effort_uom) actual_effort
3107: FROM jtf_tasks_b t
3108: WHERE t.task_id = p_parent_task_id
3109: AND NVL(t.deleted_flag, 'N') <> 'Y';
3110:
3111: CURSOR c_new_parent_info IS

Line 3118: FROM jtf_tasks_b t

3114: , MAX(t.scheduled_end_date) scheduled_end_date
3115: , MIN(t.actual_start_date) actual_start_date
3116: , MAX(t.actual_end_date) actual_end_date
3117: , SUM(csf_util_pvt.convert_to_minutes(t.actual_effort, t.actual_effort_uom)) actual_effort
3118: FROM jtf_tasks_b t
3119: , jtf_task_statuses_b ts
3120: WHERE t.parent_task_id = p_parent_task_id
3121: AND NVL(t.deleted_flag, 'N') <> 'Y'
3122: AND ts.task_status_id = t.task_status_id

Line 3139: FROM jtf_tasks_b t

3135: , NVL(ts.cancelled_flag, 'N') cancelled_flag
3136: , NVL(ts.accepted_flag, 'N') accepted_flag
3137: , NVL(ts.assignment_status_flag, 'N') assignment_status_flag
3138: , 0 status_bitcode
3139: FROM jtf_tasks_b t
3140: , jtf_task_statuses_b ts
3141: WHERE t.parent_task_id = p_parent_task_id
3142: AND ts.task_status_id = t.task_status_id
3143: AND NVL(t.deleted_flag, 'N') <> 'Y'

Line 3386: FROM jtf_tasks_b t ,jtf_task_statuses_b ts

3382: , NVL(t.child_position, '@@') child_position
3383: , NVL(t.child_sequence_num, -1) child_sequence_num
3384: , RANK() OVER (ORDER BY t.scheduled_start_date, t.scheduled_end_date,nvl(t.child_sequence_num,-1)) correct_seq_num
3385: , LEAD (t.task_id) OVER (ORDER BY t.scheduled_start_date, t.scheduled_end_date,nvl(t.child_sequence_num,-1)) next_task_id
3386: FROM jtf_tasks_b t ,jtf_task_statuses_b ts
3387: WHERE t.parent_task_id = p_parent_task_id
3388: AND NVL(t.deleted_flag, 'N') <> 'Y'
3389: AND ts.task_status_id = t.task_status_id
3390: AND NVL(ts.cancelled_flag, 'N') <> 'Y';

Line 3392: l_child_position jtf_tasks_b.child_position%TYPE;

3388: AND NVL(t.deleted_flag, 'N') <> 'Y'
3389: AND ts.task_status_id = t.task_status_id
3390: AND NVL(ts.cancelled_flag, 'N') <> 'Y';
3391:
3392: l_child_position jtf_tasks_b.child_position%TYPE;
3393: BEGIN
3394: SAVEPOINT csf_sync_child_from_parent;
3395:
3396: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 3508: FROM jtf_tasks_b t

3504: AND NVL(ats.cancelled_flag, 'N') <> 'Y'
3505: AND ROWNUM = 1
3506: ), 'N'
3507: ) is_scheduled
3508: FROM jtf_tasks_b t
3509: WHERE t.task_id = p_task_id;
3510:
3511: CURSOR c_task_assignment_info IS
3512: SELECT ta.resource_id

Line 3544: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_task_id);

3540: FETCH c_task_info INTO l_task_info;
3541: CLOSE c_task_info;
3542:
3543: IF l_task_info.task_id IS NULL THEN
3544: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_task_id);
3545: RAISE fnd_api.g_exc_unexpected_error;
3546: END IF;
3547:
3548: -- If the Task is already Scheduled, then the Task Should be treated to be

Line 3735: FROM jtf_tasks_b t , jtf_task_assignments ta

3731: , scheduled_start_date
3732: , scheduled_end_date
3733: , ta.assignment_status_id
3734: , ta.object_capacity_id
3735: FROM jtf_tasks_b t , jtf_task_assignments ta
3736: WHERE t.task_id = p_task_id
3737: AND ta.task_id = t.task_id
3738: AND ta.task_assignment_id = p_task_assignment_id;
3739:

Line 4005: FROM jtf_tasks_b t

4001: , t.scheduled_end_date
4002: , t.planned_effort
4003: , t.planned_effort_uom
4004: , t.task_split_flag
4005: FROM jtf_tasks_b t
4006: WHERE t.task_id = p_task_id;
4007:
4008: CURSOR c_child_tasks IS
4009: SELECT t.task_id

Line 4015: FROM jtf_tasks_b t ,jtf_task_statuses_b ts ,jtf_task_assignments ta

4011: , t.task_status_id
4012: , ta.task_assignment_id
4013: , ta.object_version_number task_assignment_ovn
4014: , ta.assignment_status_id
4015: FROM jtf_tasks_b t ,jtf_task_statuses_b ts ,jtf_task_assignments ta
4016: WHERE t.parent_task_id = p_task_id
4017: AND NVL(t.deleted_flag, 'N') <> 'Y'
4018: AND ts.task_status_id = t.task_status_id
4019: AND NVL(ts.cancelled_flag, 'N') <> 'Y'

Line 4046: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_task_id);

4042: FETCH c_parent_task_info INTO l_parent_task_info;
4043: CLOSE c_parent_task_info;
4044:
4045: IF l_parent_task_info.task_id IS NULL THEN
4046: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_task_id);
4047: RAISE fnd_api.g_exc_unexpected_error;
4048: END IF;
4049:
4050: -- Find out whether the new Task Status is valid.

Line 4246: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_parent_task_id);

4242: OPEN c_parent_task_info;
4243: FETCH c_parent_task_info INTO l_parent_task_info;
4244: IF c_parent_task_info%NOTFOUND THEN
4245: CLOSE c_parent_task_info;
4246: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_parent_task_id);
4247: RAISE fnd_api.g_exc_unexpected_error;
4248: END IF;
4249: CLOSE c_parent_task_info;
4250:

Line 4457: FROM jtf_tasks_b t

4453: SELECT t.task_id
4454: , t.task_split_flag
4455: , t.parent_task_id
4456: , t.task_confirmation_status
4457: FROM jtf_tasks_b t
4458: WHERE t.task_id = p_task_id;
4459:
4460: CURSOR c_parent_child_tasks (p_task_id NUMBER) IS
4461: SELECT jtb.task_id

Line 4463: FROM jtf_task_statuses_vl ts, jtf_tasks_b jtb

4459:
4460: CURSOR c_parent_child_tasks (p_task_id NUMBER) IS
4461: SELECT jtb.task_id
4462: , jtb.object_version_number
4463: FROM jtf_task_statuses_vl ts, jtf_tasks_b jtb
4464: WHERE jtb.parent_task_id = p_task_id
4465: AND ts.task_status_id = jtb.task_status_id
4466: AND jtb.task_split_flag = 'D'
4467: AND ( NVL(ts.on_hold_flag, 'N') = 'Y'

Line 4478: FROM jtf_tasks_b t

4474: AND NVL(ts.rejected_flag, 'N') <> 'Y' ))
4475: UNION
4476: SELECT t.task_id
4477: , t.object_version_number
4478: FROM jtf_tasks_b t
4479: WHERE task_id = p_task_id;
4480:
4481: l_cust_task_tbl jtf_number_table := jtf_number_table();
4482: l_cust_objver_tbl jtf_number_table := jtf_number_table();

Line 4632: FROM jtf_tasks_b t

4628: WHERE ps.party_site_id = p_party_site_id;
4629:
4630: CURSOR c_task_location IS
4631: SELECT NVL(t.location_id, ps.location_id)
4632: FROM jtf_tasks_b t
4633: , hz_party_sites ps
4634: WHERE t.task_id = p_task_id
4635: AND ps.party_site_id(+) = t.address_id;
4636:

Line 4701: FROM jtf_tasks_b t

4697: , l.city
4698: , l.state
4699: , l.province
4700: , l.country
4701: FROM jtf_tasks_b t
4702: , hz_party_sites ps
4703: , hz_locations l
4704: WHERE t.task_id = p_task_id
4705: AND ps.party_site_id(+) = t.address_id

Line 4784: * Split Flag are passed, then it helps in better performance as JTF_TASKS_B

4780: * the profile CSF: Default Effort UOM by calling
4781: * CSF_UTIL_PVT.GET_EFFORT_IN_DEFAULT_UOM function.
4782: *
4783: * All parameters are optional. If Planned Effort, Planned Effort UOM and Task
4784: * Split Flag are passed, then it helps in better performance as JTF_TASKS_B
4785: * wont be queried to get those information. In case of better flexibility,
4786: * the caller can just pass the Task ID and the API will fetch the required
4787: * information. If case none of the required parameters are passed, the API returns
4788: * NULL.

Line 4820: l_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;

4816: )
4817: RETURN VARCHAR2 IS
4818:
4819: l_effort NUMBER;
4820: l_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
4821: l_task_split_flag jtf_tasks_b.task_split_flag%TYPE;
4822:
4823: CURSOR c_task_info IS
4824: SELECT NVL(p_planned_effort, planned_effort) planned_effort

Line 4821: l_task_split_flag jtf_tasks_b.task_split_flag%TYPE;

4817: RETURN VARCHAR2 IS
4818:
4819: l_effort NUMBER;
4820: l_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
4821: l_task_split_flag jtf_tasks_b.task_split_flag%TYPE;
4822:
4823: CURSOR c_task_info IS
4824: SELECT NVL(p_planned_effort, planned_effort) planned_effort
4825: , NVL(p_planned_effort_uom, planned_effort_uom) planned_effort_uom

Line 4827: FROM jtf_tasks_b

4823: CURSOR c_task_info IS
4824: SELECT NVL(p_planned_effort, planned_effort) planned_effort
4825: , NVL(p_planned_effort_uom, planned_effort_uom) planned_effort_uom
4826: , decode(p_task_split_flag, '@', task_split_flag, p_task_split_flag) task_split_flag
4827: FROM jtf_tasks_b
4828: WHERE task_id = p_task_id;
4829: BEGIN
4830: l_effort := p_planned_effort;
4831: l_effort_uom := p_planned_effort_uom;

Line 5171: from jtf_tasks_b

5167:
5168: cursor c_obj(p_task number)
5169: is
5170: select object_version_number
5171: from jtf_tasks_b
5172: where task_id =p_task;
5173:
5174: cursor c_task_ass(p_task_id number)
5175: is

Line 5177: from jtf_task_assignments jta,jtf_tasks_b jt

5173:
5174: cursor c_task_ass(p_task_id number)
5175: is
5176: select jta.task_assignment_id
5177: from jtf_task_assignments jta,jtf_tasks_b jt
5178: where jt.task_id=p_task_id
5179: and jta.task_id=jt.task_id
5180: and jt.source_object_type_code = 'TASK'
5181: and jt.task_type_id not in (20,21);

Line 5723: from jtf_tasks_b t, hz_party_sites ps

5719: t.location_id,
5720: t.address_id,
5721: t.customer_id,
5722: NVL(t.location_id, ps.location_id) loc_id
5723: from jtf_tasks_b t, hz_party_sites ps
5724: where task_id=p_task_id
5725: AND ps.party_site_id(+) = t.address_id;
5726: l_task_dtls c_task_details%rowtype;
5727:

Line 5866: from jtf_tasks_b

5862:
5863: cursor c_task_type
5864: is
5865: select task_type_id
5866: from jtf_tasks_b
5867: where task_id = l_task_id;
5868:
5869:
5870: BEGIN