APPS.FII_GL_COST_CENTER_PKG dependencies on FII_CC_MGR_HIERARCHIES

Line 13: select mgr_level into mgr_level from fii_cc_mgr_hierarchies where EMP_ID = l_mgr_id and DIRECT_ID = l_mgr_id and MGR_ID = l_mgr_id;

9: mgr_level NUMBER;
10:
11:
12: BEGIN
13: select mgr_level into mgr_level from fii_cc_mgr_hierarchies where EMP_ID = l_mgr_id and DIRECT_ID = l_mgr_id and MGR_ID = l_mgr_id;
14: if (mgr_level = 1) THEN
15: mgr_is_topnode := 'Y';
16: ELSE
17: mgr_is_topnode := 'N';