APPS.FII_GL_COMCCH_C dependencies on FII_DIM_MAPPING_RULES

Line 384: fii_dim_mapping_rules map

380: FROM FII_COM_CC_MAPPINGS_GT dim1,
381: (select map.chart_of_accounts_id a,
382: fsav.segment_attribute_type b
383: from FND_SEGMENT_ATTRIBUTE_VALUES fsav,
384: fii_dim_mapping_rules map
385: where fsav.application_id = 101
386: and fsav.id_flex_code = 'GL#'
387: and map.dimension_short_name = 'FII_LOB'
388: and map.chart_of_accounts_id = fsav.id_flex_num

Line 528: fii_dim_mapping_rules map

524: from FII_COM_CC_MAPPINGS_GT dim1,
525: (select map.chart_of_accounts_id a,
526: fsav.segment_attribute_type b
527: from FND_SEGMENT_ATTRIBUTE_VALUES fsav,
528: fii_dim_mapping_rules map
529: where fsav.application_id = 101
530: and fsav.id_flex_code = 'GL#'
531: and map.dimension_short_name = 'FII_LOB'
532: and map.chart_of_accounts_id = fsav.id_flex_num

Line 816: -- to a real coa defined in FII_DIM_MAPPING_RULES

812:
813: -----------------------------------------------------------------
814: -- PROCEDURE HANDLE_MISSING_COA
815: -- This procedure will update -1 of coa_id in FII_COM_CC_MAPPINGS_GT
816: -- to a real coa defined in FII_DIM_MAPPING_RULES
817: -----------------------------------------------------------------
818: Procedure HANDLE_MISSING_COA IS
819:
820: l_com_vs_id number (15);

Line 877: from fii_dim_mapping_rules

873: and ID_FLEX_CODE = 'GL#'
874: and FLEX_VALUE_SET_ID = l_cc_vs_id
875: intersect
876: select CHART_OF_ACCOUNTS_ID coa_id
877: from fii_dim_mapping_rules
878: where DIMENSION_SHORT_NAME = 'FII_LOB') coa
879: where rownum = 1;
880:
881: update FII_COM_CC_MAPPINGS_GT