APPS.FII_FA_CAT_C dependencies on FA_CATEGORIES

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 889: FROM fa_categories;

885: End if;
886:
887: SELECT max(category_id)
888: INTO g_new_max_cat_id
889: FROM fa_categories;
890:
891: If g_debug_flag = 'Y' then
892: FII_UTIL.Write_Log(l_calling_fn || ': g_max_cat_id: ' || to_char(g_max_cat_id));
893: End if;

Line 1000: g_phase := 'SELECT FROM fa_categories';

996: g_max_cat_id := 0;
997:
998: END IF;
999:
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;

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';