DBA Data[Home] [Help]

APPS.BISVIEWER_PMF dependencies on BIS_LEVELS

Line 438: From BIS_LEVELS

434:
435: /*
436: Select LEVEL_ID
437: Into l_level_id
438: From BIS_LEVELS
439: Where short_name = p_Level_Short_Name ;
440: -- */
441: --/*
442: -- aleung, 11/08/00, use API to access PMF table BIS_LEVELS

Line 442: -- aleung, 11/08/00, use API to access PMF table BIS_LEVELS

438: From BIS_LEVELS
439: Where short_name = p_Level_Short_Name ;
440: -- */
441: --/*
442: -- aleung, 11/08/00, use API to access PMF table BIS_LEVELS
443: l_Level_Rec.Dimension_Level_Short_Name := p_Level_Short_Name;
444: /*
445: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level(p_api_version => 1.0,
446: p_Dimension_Level_Rec => l_Level_Rec,

Line 1336: FROM bis_levels

1332: WHERE short_name = pDimShortName;
1333:
1334: CURSOR c_dimlvls(p_dim_id IN NUMBER, p_search_string IN VARCHAR2) IS
1335: SELECT short_name
1336: FROM bis_levels
1337: where short_name like p_Search_string AND
1338: dimension_id= p_dim_id;
1339: l_dim_id NUMBER;
1340: l_search_string VARCHAR2(32000);