[Home] [Help]
84: BEGIN
85: SELECT nvl(h.hierarchy_obj_id, -1), o.object_name
86: INTO pv_hier_obj_id,
87: pv_hier_rule_obj_name
88: FROM fem_object_definition_b b,
89: fem_object_catalog_vl o,
90: fem_intg_hier_rules h
91: WHERE b.object_definition_id = pv_hier_rule_obj_def_id
92: AND b.object_id = o.object_id
176: pv_aol_vs_id,
177: pv_flatten_hier_flag,
178: pv_sequence_enforced_flag
179: FROM fem_intg_hier_rules hir,
180: fem_object_definition_b b1,
181: fem_intg_dim_rules dr,
182: fem_intg_dim_rule_defs drf,
183: fem_intg_hier_def_segs seg,
184: fnd_flex_values v,
249: v_app_col_name3,
250: v_app_col_name4,
251: v_app_col_name5
252: FROM fem_intg_hier_rules hir,
253: fem_object_definition_b b1,
254: fem_intg_dim_rules dr,
255: fem_intg_dim_rule_defs drf,
256: fem_intg_hier_def_segs seg,
257: fnd_flex_values v,
877: FROM fem_intg_dim_hier_gt inner_gt)
878: AND m.'||pv_dim_memb_col||' NOT IN
879: (SELECT mh.parent_id
880: FROM '||pv_dim_hier_tab||' mh,
881: fem_object_definition_b odb,
882: fem_intg_hier_rules ihr
883: WHERE mh.hierarchy_obj_def_id = odb.object_definition_id
884: AND odb.object_id = ihr.hierarchy_obj_id
885: AND ihr.dim_rule_obj_def_id = '||pv_dim_rule_obj_def_id||'
2719: pv_folder_id,
2720: pv_hier_rule_obj_def_id,
2721: pv_hier_rule_start_date,
2722: pv_hier_rule_end_date
2723: FROM fem_object_definition_b b,
2724: fem_object_catalog_b o
2725: WHERE b.object_definition_id = p_hier_rule_obj_def_id
2726: AND o.object_id = b.object_id
2727: AND o.object_type_code='OGL_INTG_HIER_RULE';