APPS.FII_FA_CAT_C dependencies on FA_CATEGORIES_B

Line 558: FA_CATEGORIES_B cat,

554: ' || g_fii_login_id || ' , '; -- completed below
555:
556: l_from_stmt :=
557: ' FROM fnd_id_flex_segments seg1,
558: FA_CATEGORIES_B cat,
559: FA_SYSTEM_CONTROLS sys, '; -- completed below
560:
561: l_where_stmt :=
562: ' WHERE cat.category_id > ' || p_max_cat_id || '

Line 793: -- Note that original g_new_max_cat_id is from FA_CATEGORIES_B,

789: -- may not necessary be the largest ID that was inserted.
790: -- New ids could have been created while the program is
791: -- running. So record this max cat id from fii_fa_cat_dimensions
792: --
793: -- Note that original g_new_max_cat_id is from FA_CATEGORIES_B,
794: --------------------------------------------------------------
795:
796: g_phase := 'SELECT FROM fii_fa_cat_dimensions';
797:

Line 1004: FROM fa_categories_b;

1000: g_phase := 'SELECT FROM fa_categories';
1001:
1002: SELECT max(category_id)
1003: INTO g_new_max_cat_id
1004: FROM fa_categories_b;
1005:
1006: IF (g_new_max_cat_id > g_max_cat_id) THEN
1007:
1008: g_phase := 'Insert new CAT IDs into FII_FA_CAT_DIMENSIONS table';