APPS.GCS_IC_LOB_ELIM_PARENT_PKG dependencies on FEM_USER_DIM1_B

Line 63: FROM fem_user_dim1_b fudb,

59: fudb.enabled_flag,
60: fudb.personal_flag,
61: fudb.read_only_flag,
62: fudb.object_version_number
63: FROM fem_user_dim1_b fudb,
64: fem_user_dim1_hier fudh
65: WHERE fudh.hierarchy_obj_def_id = l_hierarchy_obj_def_id
66: AND fudh.parent_id <> fudh.child_id
67: AND fudh.parent_value_set_id = fudb.value_set_id

Line 189: INSERT INTO fem_user_dim1_b

185: fnd_file.put_line(fnd_file.log, '.............Beginning Generation of Eliminations LOBs (_B Records).............');
186: g_no_rows := 0;
187: --SKAMDAR: Can change this into bulk statement in future.
188: FOR v_additional_lobs IN c_additional_lobs LOOP
189: INSERT INTO fem_user_dim1_b
190: (user_dim1_id,
191: value_set_id,
192: user_dim1_display_code,
193: enabled_flag,

Line 250: FROM fem_user_dim1_b fudb,

246: g_fnd_user_id,
247: g_fnd_user_id,
248: sysdate,
249: g_fnd_login_id
250: FROM fem_user_dim1_b fudb,
251: fnd_languages fl
252: WHERE fl.installed_flag in ('I', 'B')
253: AND fudb.user_dim1_display_code like '%'||l_elims_const
254: AND NOT EXISTS

Line 297: fem_user_dim1_b fudb

293: DECODE(fdab.attribute_varchar_label, 'SOURCE_SYSTEM_CODE', fdab.default_assignment, NULL),
294: DECODE(fdab.attribute_varchar_label, 'RECON_LEAF_NODE_FLAG', fdab.default_assignment, NULL)
295: FROM fem_dim_attributes_b fdab,
296: fem_dim_attr_versions_b fdavb,
297: fem_user_dim1_b fudb
298: WHERE fudb.value_set_id = l_value_set_id
299: AND fudb.user_dim1_display_code LIKE '%'||l_elims_const
300: AND fdab.dimension_id = 19
301: AND fdab.attribute_id = fdavb.attribute_id

Line 344: fem_user_dim1_b fudb,

340: g_fnd_login_id ,
341: 1,
342: 'N'
343: FROM fem_user_dim1_hier fudh,
344: fem_user_dim1_b fudb,
345: fem_user_dim1_b fudb1
346: WHERE fudh.hierarchy_obj_def_id = l_hierarchy_obj_def_id
347: AND fudh.parent_id <> fudh.child_id
348: AND fudh.parent_id = fudb.user_dim1_id

Line 345: fem_user_dim1_b fudb1

341: 1,
342: 'N'
343: FROM fem_user_dim1_hier fudh,
344: fem_user_dim1_b fudb,
345: fem_user_dim1_b fudb1
346: WHERE fudh.hierarchy_obj_def_id = l_hierarchy_obj_def_id
347: AND fudh.parent_id <> fudh.child_id
348: AND fudh.parent_id = fudb.user_dim1_id
349: AND fudh.parent_value_set_id = fudb.value_set_id

Line 446: fem_user_dim1_b parent,

442: USERENV('LANG')
443: FROM fem_user_dim1_hier fudh,
444: fem_object_definition_tl fodt,
445: fem_object_catalog_tl foct,
446: fem_user_dim1_b parent,
447: fem_user_dim1_b child
448: WHERE fudh.hierarchy_obj_def_id = l_hierarchy_obj_def_id
449: AND fudh.hierarchy_obj_def_id = fodt.object_definition_id
450: AND fodt.language = userenv('LANG')

Line 447: fem_user_dim1_b child

443: FROM fem_user_dim1_hier fudh,
444: fem_object_definition_tl fodt,
445: fem_object_catalog_tl foct,
446: fem_user_dim1_b parent,
447: fem_user_dim1_b child
448: WHERE fudh.hierarchy_obj_def_id = l_hierarchy_obj_def_id
449: AND fudh.hierarchy_obj_def_id = fodt.object_definition_id
450: AND fodt.language = userenv('LANG')
451: AND fodt.object_id = foct.object_id