APPS.BIS_TARGET_LEVEL_PVT dependencies on BIS_TARGET_LEVELS_S

Line 783: select bis_target_levels_s.NEXTVAL into l_id from dual;

779: END IF;
780:
781:
782:
783: select bis_target_levels_s.NEXTVAL into l_id from dual;
784: --
785:
786: insert into bis_TARGET_LEVELS (
787: TARGET_LEVEL_ID,

Line 4258: UPDATE bis_target_levels SET last_updated_by = 1 , created_by = 1, short_name = p_tl_new_short_name

4254:
4255: l_pm_count := l_pm_count + 1;
4256:
4257: IF p_tl_new_short_name IS NOT NULL THEN
4258: UPDATE bis_target_levels SET last_updated_by = 1 , created_by = 1, short_name = p_tl_new_short_name
4259: WHERE current of c_updt1;
4260: ELSE
4261: UPDATE bis_target_levels SET last_updated_by = 1 , created_by = 1
4262: WHERE current of c_updt1;

Line 4261: UPDATE bis_target_levels SET last_updated_by = 1 , created_by = 1

4257: IF p_tl_new_short_name IS NOT NULL THEN
4258: UPDATE bis_target_levels SET last_updated_by = 1 , created_by = 1, short_name = p_tl_new_short_name
4259: WHERE current of c_updt1;
4260: ELSE
4261: UPDATE bis_target_levels SET last_updated_by = 1 , created_by = 1
4262: WHERE current of c_updt1;
4263: END IF;
4264:
4265: UPDATE bis_target_levels_tl SET last_updated_by = 1 , created_by = 1