DBA Data[Home] [Help]

APPS.BIS_PMF_MIGRATION_PVT dependencies on BIS_TARGET_VALUES

Line 515: FROM bis_target_values

511: CURSOR c_targetlvl_values(p_target_level_id IN NUMBER) IS
512: SELECT target_id, org_level_value, time_level_value
513: ,dimension1_level_value, dimension2_level_value, dimension3_level_value
514: ,dimension4_level_value, dimension5_level_value
515: FROM bis_target_values
516: WHERE target_level_id = p_target_level_id;
517: CURSOR c_actual_values(p_target_level_id IN NUMBER) IS
518: SELECT actual_id, target_level_id, org_level_value, time_level_value,
519: dimension1_level_value, dimension2_level_value

Line 693: l_sqlstmt1 := 'UPDATE bis_target_values SET '||

689: ,x_reseq_dim_values => l_reseq_target_values
690: ,x_return_Status => l_return_status
691: );
692: IF ((l_return_status = 0) AND (l_reseq_target_values.COUNT > 0)) THEN
693: l_sqlstmt1 := 'UPDATE bis_target_values SET '||
694: l_reseq_target_values(1).dim_level_name ||' = :1 '||
695: ' ,'|| l_Reseq_target_values(2).dim_level_name ||' = :2 ' ||
696: ' ,' || l_Reseq_target_values(3).dim_level_name ||' = :3 '||
697: ' ,' || l_Reseq_target_values(4).dim_level_name||' = :4 ' ||