1249: AND rownum = 1;
1250:
1251: cursor c_scheduled_start is
1252: select scheduled_start_date
1253: from jtf_tasks_b
1254: where task_id = p_task_id;
1255:
1256: cursor c_available_parts(p_task_id number) is
1257: select distinct capt.supplied_item_id,
3807:
3808: cursor c_sr_org_id is
3809: select cia.org_id
3810: from cs_incidents_all cia,
3811: jtf_tasks_b jtb
3812: where jtb.task_id = p_task_id
3813: and jtb.source_object_type_code = 'SR'
3814: and cia.incident_id = jtb.source_object_id;
3815: