DBA Data[Home] [Help]

APPS.FII_COM_CC_DIM_MAPS_PKG dependencies on FII_FULL_COST_CTR_HIERS

Line 197: FROM FII_FULL_COST_CTR_HIERS fh

193: (SELECT ph.parent_COMPANY_id
194: FROM FII_COMPANY_HIERARCHIES ph
195: WHERE ph.is_leaf_flag = 'Y')) h1,
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