APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_TCS_ALL_OBJECTS_IN_CAT

Line 466: UPDATE BEN_TCS_ALL_OBJECTS_IN_CAT

462:
463: IF (item_hrchy_values(i).lvl_num = 1) THEN
464:
465: hr_utility.set_location('Updating the statement generated flag .all_objects_in_cat_id:'|| item_hrchy_values(i).all_objects_id ,56);
466: UPDATE BEN_TCS_ALL_OBJECTS_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);

Line 620: UPDATE ben_tcs_all_objects_in_cat

616: OPEN c_obj_cat_id(all_obj_cat(j),l_rep_rec(i).PERIOD_ID);
617: FETCH c_obj_cat_id INTO l_obj_id;
618: IF (c_obj_cat_id % NOTFOUND) THEN
619: hr_utility.set_location('Stmt Generated flag reset for obj' || all_obj_cat(j),66);
620: UPDATE ben_tcs_all_objects_in_cat
621: SET stmt_generated_flag = null
622: WHERE all_objects_in_cat_id = all_obj_cat(j);
623: END IF;
624: CLOSE c_obj_cat_id ;