APPS.FII_FIN_CAT_MAINTAIN_PKG dependencies on FII_FC_TYPE_NORM_ASSIGN

Line 1304: -- Populate the table FII_FIN_CAT_TYPE_ASSGNS from FII_FC_TYPE_NORM_ASSIGN

1300: END Check_rules_denorm;
1301:
1302:
1303: -- **************************************************************************
1304: -- Populate the table FII_FIN_CAT_TYPE_ASSGNS from FII_FC_TYPE_NORM_ASSIGN
1305: -- by traveraling the dimension hierarchy table
1306:
1307: Procedure Populate_FCT_denorm (p_initial_load VARCHAR2) IS
1308:

Line 1324: --can be assigned to same type in FII_FC_TYPE_NORM_ASSIGN

1320: FII_UTIL.truncate_table ('FII_FC_TYPE_ASSGNS_GT', 'FII', g_retcode);
1321:
1322: --First, insert records into the denorm TMP table
1323: --Note that we need to use DISTINCT here since both parent-child
1324: --can be assigned to same type in FII_FC_TYPE_NORM_ASSIGN
1325: g_phase := 'insert records into the denorm TMP table';
1326:
1327: Insert into FII_FC_TYPE_ASSGNS_GT
1328: (fin_cat_type_code,

Line 1335: from FII_FC_TYPE_NORM_ASSIGN fcn,

1331: select distinct
1332: fcn.fin_cat_type_code,
1333: hier.child_fin_cat_id,
1334: 'N'
1335: from FII_FC_TYPE_NORM_ASSIGN fcn,
1336: FII_FULL_FIN_ITEM_HIERS hier
1337: where fcn.fin_category_id = hier.parent_fin_cat_id;
1338:
1339: l_sql_rowcount := SQL%ROWCOUNT;