APPS.FII_COM_CC_DIM_MAPS_PKG dependencies on FII_COST_CTR_HIERARCHIES

Line 200: FROM FII_COST_CTR_HIERARCHIES ph

196: (SELECT fh.parent_cc_id, fh.child_cc_id
197: FROM FII_FULL_COST_CTR_HIERS fh
198: WHERE fh.parent_cc_id IN
199: (SELECT ph.parent_cc_id
200: FROM FII_COST_CTR_HIERARCHIES ph
201: WHERE ph.is_leaf_flag = 'Y')) h2
202: WHERE DECODE(G_CO_MAP_SEG,
203: 'BALANCING', g.COMPANY_ID,
204: 'COST CENTER', g.cost_center_id, G_UNASSIGNED_ID) =