APPS.BIS_PMF_GET_DIMLEVELS_PVT dependencies on BIS_LEVELS_VL

Line 1036: FROM bis_levels_vl

1032: IS
1033: l_api_name VARCHAR2(200) :=' GET_DIMLEVEL_SELECT_STRING';
1034: CURSOR c_dims IS
1035: SELECT source, name,description , short_name, level_values_view_name
1036: FROM bis_levels_vl
1037: WHERE level_id = p_bis_dimlevel_id
1038: ;
1039: l_short_name BIS_LEVELS_VL.SHORT_NAME%TYPE;
1040: l_source BIS_LEVELS_VL.SOURCE%TYPE;

Line 1039: l_short_name BIS_LEVELS_VL.SHORT_NAME%TYPE;

1035: SELECT source, name,description , short_name, level_values_view_name
1036: FROM bis_levels_vl
1037: WHERE level_id = p_bis_dimlevel_id
1038: ;
1039: l_short_name BIS_LEVELS_VL.SHORT_NAME%TYPE;
1040: l_source BIS_LEVELS_VL.SOURCE%TYPE;
1041: l_level_name BIS_LEVELS_VL.NAME%TYPE;
1042: l_description BIS_LEVELS_VL.DESCRIPTION%TYPE;
1043: l_time_level VARCHAR2(2001);

Line 1040: l_source BIS_LEVELS_VL.SOURCE%TYPE;

1036: FROM bis_levels_vl
1037: WHERE level_id = p_bis_dimlevel_id
1038: ;
1039: l_short_name BIS_LEVELS_VL.SHORT_NAME%TYPE;
1040: l_source BIS_LEVELS_VL.SOURCE%TYPE;
1041: l_level_name BIS_LEVELS_VL.NAME%TYPE;
1042: l_description BIS_LEVELS_VL.DESCRIPTION%TYPE;
1043: l_time_level VARCHAR2(2001);
1044: l_level_values_view_name VARCHAR2(32000);

Line 1041: l_level_name BIS_LEVELS_VL.NAME%TYPE;

1037: WHERE level_id = p_bis_dimlevel_id
1038: ;
1039: l_short_name BIS_LEVELS_VL.SHORT_NAME%TYPE;
1040: l_source BIS_LEVELS_VL.SOURCE%TYPE;
1041: l_level_name BIS_LEVELS_VL.NAME%TYPE;
1042: l_description BIS_LEVELS_VL.DESCRIPTION%TYPE;
1043: l_time_level VARCHAR2(2001);
1044: l_level_values_view_name VARCHAR2(32000);
1045: BEGIN

Line 1042: l_description BIS_LEVELS_VL.DESCRIPTION%TYPE;

1038: ;
1039: l_short_name BIS_LEVELS_VL.SHORT_NAME%TYPE;
1040: l_source BIS_LEVELS_VL.SOURCE%TYPE;
1041: l_level_name BIS_LEVELS_VL.NAME%TYPE;
1042: l_description BIS_LEVELS_VL.DESCRIPTION%TYPE;
1043: l_time_level VARCHAR2(2001);
1044: l_level_values_view_name VARCHAR2(32000);
1045: BEGIN
1046: FND_MSG_PUB.initialize;