903:
904: cursor c_task_status(l_task number)
905: is
906: select name
907: from jtf_task_statuses_tl jl
908: where jl.task_status_id=l_task
909: and language=userenv('lang');
910:
911: cursor c_scheduled_dates(p_task_id number)
1300: where task_id=l_task;
1301: Cursor c_task_status(l_task number)
1302: IS
1303: select name
1304: from jtf_task_statuses_tl jl
1305: where jl.task_status_id=l_task
1306: and language=userenv('lang');
1307:
1308:
1832:
1833: cursor c_task_status(l_task number)
1834: is
1835: select name
1836: from jtf_task_statuses_tl jl
1837: where jl.task_status_id=l_task
1838: and language=userenv('lang');
1839:
1840: scheduled_dates c_scheduled_dates%rowtype;