APPS.BEN_TCS_STMT_VALID_HRCHY dependencies on BEN_TCS_CAT_SUBCAT_HRCHY

Line 56: FROM ben_tcs_cat_subcat_hrchy cat_subcat_hr

52:
53: CURSOR c_cat_hrchy (v_cat_id IN NUMBER, v_stmt_id NUMBER , v_period_id NUMBER)
54: IS
55: SELECT sub_cat_id, lvl_num
56: FROM ben_tcs_cat_subcat_hrchy cat_subcat_hr
57: WHERE cat_subcat_hr.cat_id = v_cat_id
58: AND cat_subcat_hr.stmt_id = v_stmt_id
59: ANd cat_subcat_hr.stmt_perd_id = v_period_id ;
60:

Line 135: DELETE FROM ben_tcs_cat_subcat_hrchy

131: DELETE FROM ben_tcs_cat_item_hrchy
132: WHERE cat_id = stmt_obj_hrchy (l_counter)
133: and stmt_id = p_stmt_id
134: and stmt_perd_id = p_period_id;
135: DELETE FROM ben_tcs_cat_subcat_hrchy
136: WHERE cat_id = stmt_obj_hrchy (l_counter)
137: and stmt_id = p_stmt_id
138: and stmt_perd_id = p_period_id;
139: OPEN c_cat_subcat (l_cur_cat_id);

Line 242: INSERT INTO ben_tcs_cat_subcat_hrchy

238: subcat_hrchy_values(subcat_count +1 ).subcat_id:=l_cur_cat_id;
239: subcat_hrchy_values(subcat_count +1 ).lvl_num:=1;
240: subcat_hrchy_values(subcat_count +1 ).row_cat_id:=cat_parent_rec.row_in_cat_id;
241: subcat_hrchy_values(subcat_count +1 ).perd_id:= p_period_id;
242: INSERT INTO ben_tcs_cat_subcat_hrchy
243: (stmt_id, cat_id, sub_cat_id, lvl_num,row_in_cat_id,stmt_perd_id
244: )
245: VALUES (p_stmt_id, cat_parent_rec.cat_id, l_cur_cat_id, 1 ,cat_parent_rec.row_in_cat_id , p_period_id);
246:

Line 287: INSERT INTO ben_tcs_cat_subcat_hrchy

283: subcat_hrchy_values(subcat_count +1 ).lvl_num:=cat_hrchy_rec.lvl_num + 1;
284: subcat_hrchy_values(subcat_count +1 ).row_cat_id:=cat_parent_rec.row_in_cat_id;
285: subcat_hrchy_values(subcat_count +1 ).perd_id:=p_period_id;
286:
287: INSERT INTO ben_tcs_cat_subcat_hrchy
288: (stmt_id, cat_id,
289: sub_cat_id,
290: lvl_num,
291: row_in_cat_id ,stmt_perd_id