APPS.FII_GL_UTIL_PKG dependencies on FII_LOB_HIERARCHIES

Line 224: FROM fii_lob_hierarchies;

220:
221: If l_lob_enabled_flag = 'N' THEN
222: IF g_lob_id IS NULL OR g_lob_id = 'ALL' THEN
223: SELECT parent_lob_id INTO g_lob_id
224: FROM fii_lob_hierarchies;
225:
226: g_lob_is_top_node := 'N';
227:
228: END IF;

Line 1020: g_lob_from_clause := ' ,fii_lob_hierarchies lob';

1016: g_lob_join := ' AND f.line_of_business_id = :LOB_ID ';
1017: ELSE
1018: g_lob_join := ' AND lob.parent_lob_id = :LOB_ID
1019: AND lob.child_lob_id = f.line_of_business_id';
1020: g_lob_from_clause := ' ,fii_lob_hierarchies lob';
1021: END IF;
1022: END IF;
1023: END IF;
1024:

Line 1795: FROM fii_lob_hierarchies

1791: IF (g_lob_is_top_node = 'Y') THEN
1792: g_lob_is_leaf := 'N';
1793: ELSE
1794: SELECT IS_LEAF_FLAG INTO g_lob_is_leaf
1795: FROM fii_lob_hierarchies
1796: WHERE CHILD_LOB_ID = g_lob_id
1797: AND PARENT_LOB_ID = g_lob_id;
1798: END IF;
1799:

Line 1824: fii_lob_hierarchies x

1820:
1821: SELECT 1
1822: INTO is_within_lob
1823: FROM fii_com_cc_mappings mapp,
1824: fii_lob_hierarchies x
1825: WHERE mapp.COMPANY_COST_CENTER_ORG_ID = g_ccc_id
1826: AND x.parent_lob_id = g_lob_id
1827: AND x.child_lob_id = mapp.parent_lob_id
1828: AND rownum = 1;