APPS.BEN_TCS_STMT_VALID_HRCHY SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 28

         SELECT cat_id
           FROM ben_tcs_stmt_cat stmt_cat
          WHERE stmt_cat.stmt_id = v_stmt_id
            AND stmt_cat.business_group_id = v_bg_id;

Line: 35

         SELECT subcat_id
           FROM ben_tcs_all_objects_in_cat stmt_all_obj
          WHERE stmt_all_obj.cat_id = v_cat_id AND subcat_id IS NOT NULL;

Line: 41

         SELECT stmt_all_obj.item_id, col_cat.contributor_type_cd cntr_cd ,stmt_all_obj.all_objects_in_cat_id obj_id,
           stmt_all_obj.row_in_cat_id row_id
           FROM ben_tcs_all_objects_in_cat stmt_all_obj,  ben_tcs_col_in_cat col_cat
          WHERE stmt_all_obj.cat_id = v_cat_id AND item_id IS NOT NULL
          AND col_cat.col_in_cat_id = stmt_all_obj.col_in_cat_id;

Line: 49

         SELECT cat_id , row_in_cat_id ,all_objects_in_cat_id
           FROM ben_tcs_all_objects_in_cat stmt_all_obj
          WHERE stmt_all_obj.subcat_id = v_cat_id;

Line: 55

         SELECT sub_cat_id, lvl_num
           FROM ben_tcs_cat_subcat_hrchy cat_subcat_hr
          WHERE cat_subcat_hr.cat_id = v_cat_id
            AND cat_subcat_hr.stmt_id = v_stmt_id
            ANd cat_subcat_hr.stmt_perd_id  = v_period_id ;

Line: 63

         SELECT item_id, lvl_num,cntr_cd,row_in_cat_id ,all_objects_in_cat_id
           FROM ben_tcs_cat_item_hrchy cat_item_hr
          WHERE cat_item_hr.cat_id = v_cat_id
            AND cat_item_hr.stmt_id = v_stmt_id
            AND cat_item_hr.stmt_perd_id  = v_period_id ;

Line: 131

         DELETE FROM ben_tcs_cat_item_hrchy
         WHERE cat_id = stmt_obj_hrchy (l_counter)
         and stmt_id  = p_stmt_id
         and stmt_perd_id = p_period_id;

Line: 135

         DELETE FROM ben_tcs_cat_subcat_hrchy
         WHERE cat_id = stmt_obj_hrchy (l_counter)
         and stmt_id  = p_stmt_id
         and stmt_perd_id = p_period_id;

Line: 185

               INSERT INTO ben_tcs_cat_item_hrchy
                           (stmt_id, cat_id, item_id, lvl_num,cntr_cd ,row_in_cat_id , all_objects_in_cat_id,stmt_perd_id
                           )
                    VALUES (p_stmt_id, l_cur_cat_id, cat_item_rec.item_id, 1,cat_item_rec.cntr_cd,
                    cat_item_rec.row_id ,cat_item_rec.obj_id , p_period_id);

Line: 242

              INSERT INTO ben_tcs_cat_subcat_hrchy
                           (stmt_id, cat_id, sub_cat_id, lvl_num,row_in_cat_id,stmt_perd_id
                           )
                    VALUES (p_stmt_id, cat_parent_rec.cat_id, l_cur_cat_id, 1 ,cat_parent_rec.row_in_cat_id , p_period_id);

Line: 249

               SELECT cat_type_cd
                 INTO cat_type
                 FROM BEN_TCS_CAT
                 WHERE cat_id  = l_cur_cat_id ;

Line: 287

                     INSERT INTO ben_tcs_cat_subcat_hrchy
                                 (stmt_id, cat_id,
                                  sub_cat_id,
                                  lvl_num,
                                  row_in_cat_id ,stmt_perd_id
                                 )
                          VALUES (p_stmt_id, cat_parent_rec.cat_id,
                                  cat_hrchy_rec.sub_cat_id,
                                  cat_hrchy_rec.lvl_num + 1,
                                  cat_parent_rec.row_in_cat_id,
                                  p_period_id
                                 );

Line: 324

                       INSERT INTO ben_tcs_cat_item_hrchy
                                 (stmt_id, cat_id,
                                  item_id,
                                  lvl_num ,cntr_cd, row_in_cat_id ,all_objects_in_cat_id,stmt_perd_id
                                 )
                          VALUES (p_stmt_id, cat_parent_rec.cat_id,
                                  item_hrchy_rec.item_id,
                                  item_hrchy_rec.lvl_num + 1,
                                  item_hrchy_rec.cntr_cd,
                                  cat_parent_rec.row_in_cat_id,
                                  cat_parent_rec.all_objects_in_cat_id ,
                                  p_period_id
                                 );

Line: 353

        INSERT INTO ben_tcs_cat_item_hrchy
                                 (stmt_id, cat_id,
                                  item_id,lvl_num,cntr_cd ,stmt_perd_id)
         VALUES (p_stmt_id ,-999 ,item_table(i).item_id ,-1 ,item_table(i).cntr_cd ,item_table(i).subcat_id  );