DBA Data[Home] [Help]

APPS.BSC_UPGRADES dependencies on BIS_APPLICATION_MEASURES

Line 2489: FROM bis_application_measures bisapp,

2485: )RETURN BOOLEAN IS
2486: l_return_Status BOOLEAN;
2487: CURSOR c_update_appid IS
2488: SELECT bisapp.indicator_id
2489: FROM bis_application_measures bisapp,
2490: bis_indicators bisindic,
2491: bsc_sys_datasets_vl bsc
2492: WHERE bisapp.indicator_id = bisindic.indicator_id
2493: AND bisindic.dataset_id = bsc.dataset_id

Line 2500: UPDATE bis_application_measures

2496:
2497: BEGIN
2498: l_return_Status := TRUE;
2499: FOR cd IN c_update_appid LOOP
2500: UPDATE bis_application_measures
2501: SET application_id = 271
2502: where indicator_id = cd.indicator_id;
2503: END LOOP;
2504: