DBA Data[Home] [Help]

APPS.CSF_AUTO_COMMIT_PVT dependencies on JTF_TASKS_B

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

91:
92:
93:
94: TYPE ref_cursor_type IS REF CURSOR;
95: TYPE task_split_tbl_type IS TABLE OF jtf_tasks_b.task_split_flag%TYPE;
96: -- REF Cursor to form different query based on different conditions.
97: c_task_list ref_cursor_type;
98:
99:

Line 219: FROM jtf_tasks_b t

215: IF not (l_commit_horizon)
216: THEN
217:
218: l_query := 'SELECT DISTINCT NVL(t.parent_task_id, t.task_id) task_id
219: FROM jtf_tasks_b t
220: , jtf_task_assignments ta
221: , jtf_task_statuses_b ts
222: , (SELECT TO_NUMBER(SUBSTR(column_value
223: , 1

Line 251: FROM jtf_tasks_b t

247: OPEN c_task_list FOR l_query USING p_res_key,l_start_date;
248: ELSE
249:
250: l_query := 'SELECT DISTINCT NVL(t.parent_task_id, t.task_id) task_id
251: FROM jtf_tasks_b t
252: , jtf_task_assignments ta
253: , jtf_task_statuses_b ts
254: , (SELECT TO_NUMBER(SUBSTR(column_value
255: , 1