APPS.CSF_TASKS_PUB dependencies on CSF_DC_QUERIES_B

Line 2124: FROM csf_dc_queries_b

2120:
2121: -- Cursor to fetch the WHERE Clause corresponding to the chosen Query.
2122: CURSOR c_query_where_clause IS
2123: SELECT where_clause
2124: FROM csf_dc_queries_b
2125: WHERE query_id = p_query_id;
2126:
2127: -- Cursor to fetch all Commit Child Candidates of a Parent Task
2128: -- and only those assigned to Resources belonging to the Dispatcher's Territory.

Line 2157: l_where_clause csf_dc_queries_b.where_clause%TYPE;

2153: AND a.assignment_status_id = b.task_status_id
2154: AND nvl(b.cancelled_flag ,'N') <> 'Y';
2155: l_cnt NUMBER :=1;
2156:
2157: l_where_clause csf_dc_queries_b.where_clause%TYPE;
2158: l_query VARCHAR2(2000);
2159: l_task_id_tbl jtf_number_table;
2160: l_task_split_flag_tbl task_split_tbl_type;
2161: l_task_num_tbl jtf_number_table := jtf_number_table();