DBA Data[Home] [Help]

APPS.FII_GL_UTIL_PKG dependencies on FII_COM_CC_MAPPINGS

Line 208: FROM fii_com_cc_mappings

204: ---when specific cost center is chosen exp/rev/cogs trend reports are performing bad. so we
205: IF ((g_ccc_id IS NOT NULL) AND (g_ccc_id <> -999)) THEN
206: SELECT parent_manager_id
207: INTO g_cc_owner
208: FROM fii_com_cc_mappings
209: WHERE company_cost_center_org_id = g_ccc_id;
210: END IF;
211:
212: /* When LOB chosen is All, we assign the top node LOB id to g_lob_id */

Line 1823: FROM fii_com_cc_mappings mapp,

1819: BEGIN
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