71: ---------------------------------------
72: l_first_task_id number;
73: l_last_task_id number;
74:
75: p_res_id jtf_number_table ;
76: p_res_type jtf_varchar2_table_2000 ;
77: p_res_name jtf_varchar2_table_2000 ;
78: p_res_typ_name jtf_varchar2_table_2000 ;
79: p_res_key jtf_varchar2_table_2000 ;
76: p_res_type jtf_varchar2_table_2000 ;
77: p_res_name jtf_varchar2_table_2000 ;
78: p_res_typ_name jtf_varchar2_table_2000 ;
79: p_res_key jtf_varchar2_table_2000 ;
80: l_task_id_tbl jtf_number_table;
81: l_query VARCHAR2(2000);
82:
83: CURSOR C_Terr_Resource
84: IS SELECT DISTINCT TR.RESOURCE_ID RESOURCE_ID,