APPS.FII_GL_UTIL_PKG dependencies on FII_CC_MGR_HIERARCHIES

Line 931: g_mgr_from_clause := ', fii_cc_mgr_hierarchies h';

927: END IF;
928: ELSE
929: IF g_mgr_id = -99999 THEN g_mgr_join := ' AND h.mgr_id = -99999
930: AND h.emp_id = f.manager_id ';
931: g_mgr_from_clause := ', fii_cc_mgr_hierarchies h';
932: ELSE
933: g_mgr_join := ' AND h.mgr_id = &HRI_PERSON+HRI_PER_USRDR_H
934: AND h.emp_id = f.manager_id ';
935: g_mgr_from_clause := ', fii_cc_mgr_hierarchies h';

Line 935: g_mgr_from_clause := ', fii_cc_mgr_hierarchies h';

931: g_mgr_from_clause := ', fii_cc_mgr_hierarchies h';
932: ELSE
933: g_mgr_join := ' AND h.mgr_id = &HRI_PERSON+HRI_PER_USRDR_H
934: AND h.emp_id = f.manager_id ';
935: g_mgr_from_clause := ', fii_cc_mgr_hierarchies h';
936: END IF;
937: END IF;
938:
939: WHEN 'HRI_PERSON+HRI_PER_USRDR_H' THEN

Line 1761: FROM fii_cc_mgr_hierarchies

1757: -- manager who is already top node.
1758: -- ----------------------------------------------------------
1759:
1760: SELECT mgr_level INTO l_mgr_level
1761: FROM fii_cc_mgr_hierarchies
1762: WHERE EMP_ID = g_mgr_id
1763: AND DIRECT_ID = g_mgr_id
1764: AND MGR_ID = g_mgr_id;
1765:

Line 1768: FROM fii_cc_mgr_hierarchies

1764: AND MGR_ID = g_mgr_id;
1765:
1766: IF (l_mgr_level <> 1) THEN
1767: SELECT distinct MGR_ID INTO l_mgr_mgr_id
1768: FROM fii_cc_mgr_hierarchies
1769: WHERE DIRECT_ID = g_mgr_id
1770: AND EMP_ID = g_mgr_id
1771: AND (DIRECT_LEVEL = 1 OR MGR_ID <> DIRECT_ID);
1772: ELSE l_mgr_mgr_id := '-999';

Line 1776: FROM fii_cc_mgr_hierarchies

1772: ELSE l_mgr_mgr_id := '-999';
1773: END IF;
1774:
1775: SELECT IS_LEAF_FLAG INTO g_mgr_is_leaf
1776: FROM fii_cc_mgr_hierarchies
1777: WHERE EMP_ID = g_mgr_id
1778: AND MGR_ID = g_mgr_id;
1779:
1780: