APPS.FII_GL_COMCCH_C dependencies on FII_FULL_LOB_HIERS

Line 396: from fii_full_lob_hiers flob

392: WHERE lob.a = dim1.COA_ID
393: AND dim.COMPANY_COST_CENTER_ORG_ID = dim1.COMPANY_COST_CENTER_ORG_ID
394: AND decode (lob.b, 'GL_BALANCING', dim.company_id, dim.cost_center_id) IN
395: (select flob.child_lob_id
396: from fii_full_lob_hiers flob
397: where flob.parent_lob_id = flob.child_lob_id)
398: ), dim.LOB_ID)
399: WHERE dim.lob_id = G_UNASSIGNED_LOB_ID ;
400:

Line 429: from fii_full_lob_hiers flob,

425: Update FII_COM_CC_MAPPINGS dim
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

Line 540: from fii_full_lob_hiers flob

536: where lob.a = dim1.COA_ID
537: and dim.COMPANY_COST_CENTER_ORG_ID = dim1.COMPANY_COST_CENTER_ORG_ID
538: and decode (lob.b, 'GL_BALANCING', dim.company_id, dim.cost_center_id) IN
539: (select flob.child_lob_id
540: from fii_full_lob_hiers flob
541: where flob.parent_lob_id = flob.child_lob_id)
542: ), dim.LOB_ID)
543: WHERE dim.lob_id = G_UNASSIGNED_LOB_ID ;
544:

Line 573: from fii_full_lob_hiers flob,

569: Update FII_COM_CC_MAPPINGS1_GT dim
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