DBA Data[Home] [Help]

APPS.IEU_WR_PUB dependencies on JTF_TASK_STATUSES_VL

Line 2300: from jtf_task_statuses_vl

2296: exit when c_task%notfound;
2297:
2298: begin
2299: select 'SLEEP' into l_task_status
2300: from jtf_task_statuses_vl
2301: where (nvl(on_hold_flag,'N') = 'Y')
2302: and task_status_id = l_task_status_id;
2303: EXCEPTION WHEN no_data_found
2304: THEN

Line 7175: from jtf_task_statuses_vl

7171: exit when c_task%notfound;
7172:
7173: begin
7174: select 'SLEEP' into l_task_status
7175: from jtf_task_statuses_vl
7176: where (nvl(on_hold_flag,'N') = 'Y')
7177: and task_status_id = l_task_status_id;
7178: EXCEPTION WHEN no_data_found
7179: THEN