APPS.BIS_TARGET_LEVEL_PVT dependencies on BISBV_DIMENSIONS

Line 3365: from bisbv_dimensions

3361: CLOSE cr_tl_id_dim_level;
3362: --------
3363: Select dimension_id
3364: into l_time_dimension_id
3365: from bisbv_dimensions
3366: --'TIME'
3367: where upper(dimension_short_name) =
3368: BIS_UTILITIES_PVT.Get_Time_Dimension_Name_TL(p_Target_Level_Rec.target_level_id,NULL);
3369: --------

Line 3401: from bisbv_dimensions

3397: CLOSE cr_tl_sn_dim_level;
3398: --------
3399: Select dimension_id
3400: into l_time_dimension_id
3401: from bisbv_dimensions
3402: --'TIME'
3403: where upper(dimension_short_name) =
3404: BIS_UTILITIES_PVT.Get_Time_Dimension_Name_TL(NULL,p_Target_Level_Rec.target_level_short_name);
3405: --------

Line 3411: from bisbv_dimensions

3407: --moved this in the if condition for tl id and shortname
3408: /*
3409: Select dimension_id
3410: into l_time_dimension_id
3411: from bisbv_dimensions
3412: --'TIME'
3413: where upper(dimension_short_name) =
3414: BIS_UTILITIES_PVT.Get_Time_Dimension_Name;
3415: */

Line 3607: from bisbv_dimensions -- 'ORG'

3603: l_err_track := 500;
3604:
3605: Select dimension_id
3606: into l_org_dimension_id
3607: from bisbv_dimensions -- 'ORG'
3608: where upper(dimension_short_name) = l_dimension_short_name;
3609:
3610: l_err_track := 600;
3611:

Line 3655: from bisbv_dimensions --''ORG''

3651: l_dimension_short_name := BIS_UTILITIES_PVT.Get_Org_Dimension_Name_TL(NULL, p_Target_Level_Rec.target_level_short_name);
3652:
3653: Select dimension_id
3654: into l_org_dimension_id
3655: from bisbv_dimensions --''ORG''
3656: where upper(dimension_short_name) = l_dimension_short_name;
3657:
3658: --------
3659: