APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_TCS_ROW_IN_CAT

Line 471: UPDATE BEN_TCS_ROW_IN_CAT

467: SET stmt_generated_flag = 'Y'
468: WHERE all_objects_in_cat_id = item_hrchy_values(i).all_objects_id;
469:
470: hr_utility.set_location('Updating the statement generated flag .row_in_cat_id:'|| item_hrchy_values(i).row_cat_id,57);
471: UPDATE BEN_TCS_ROW_IN_CAT
472: SET stmt_generated = 'Y'
473: WHERE row_in_cat_id =item_hrchy_values(i).row_cat_id;
474: END IF;
475: END IF;

Line 539: UPDATE BEN_TCS_ROW_IN_CAT

535: subcat_hrchy_values(i).row_cat_id,
536: subcat_hrchy_values(i).perd_id );
537: IF ( subcat_hrchy_values(i).lvl_num =1) THEN
538: hr_utility.set_location('Updating the statement generated flag :sub_cat .row_in_cat_id:'|| subcat_hrchy_values(i).row_cat_id, 61);
539: UPDATE BEN_TCS_ROW_IN_CAT
540: SET stmt_generated = 'Y'
541: WHERE row_in_cat_id = subcat_hrchy_values(i).row_cat_id;
542: END IF;
543: END IF;

Line 608: UPDATE ben_tcs_row_in_cat

604: OPEN c_row_cat_id(row_in_cat(j) ,l_rep_rec(i).PERIOD_ID);
605: FETCH c_row_cat_id INTO l_row_id;
606: IF (c_row_cat_id % NOTFOUND) THEN
607: hr_utility.set_location('Stmt Generated flag reset for row' || row_in_cat(j),65);
608: UPDATE ben_tcs_row_in_cat
609: SET stmt_generated = null
610: WHERE row_in_cat_id = row_in_cat(j);
611: END IF;
612: CLOSE c_row_cat_id;