APPS.FII_GL_COMCCH_C dependencies on FII_LOB_HIERARCHIES

Line 430: fii_lob_hierarchies lob

426: Set dim.parent_lob_id =
427: NVL((select v.parent_lob_id
428: from (select flob.parent_lob_id, flob.child_lob_id, lob.child_level
429: from fii_full_lob_hiers flob,
430: fii_lob_hierarchies lob
431: where lob.child_lob_id = flob.parent_lob_id
432: order by lob.child_level DESC) v
433: where v.child_lob_id = dim.lob_id
434: and rownum = 1), dim.lob_id);

Line 574: fii_lob_hierarchies lob

570: Set dim.parent_lob_id =
571: NVL((select v.parent_lob_id
572: from (select flob.parent_lob_id, flob.child_lob_id, lob.child_level
573: from fii_full_lob_hiers flob,
574: fii_lob_hierarchies lob
575: where lob.child_lob_id = flob.parent_lob_id
576: order by lob.child_level DESC) v
577: where v.child_lob_id = dim.lob_id
578: and rownum = 1), dim.lob_id);