APPS.EDW_GEN_VIEW dependencies on EDW_FLEX_SEG_MAPPINGS

Line 47: from edw_fact_flex_fk_maps a, edw_flex_seg_mappings b

43: ORDER BY attribute_name;
44:
45: cursor c_getFactFlexFKMaps(p_obj_name in varchar2, p_instance in varchar2) IS
46: SELECT fk_physical_name
47: from edw_fact_flex_fk_maps a, edw_flex_seg_mappings b
48: where a.fact_short_name = p_obj_name
49: and a.dimension_short_name = b.dimension_short_name
50: and b.instance_code = p_instance
51: and a.enabled_flag = 'Y';

Line 55: from edw_fact_flex_fk_maps a, edw_flex_seg_mappings b

51: and a.enabled_flag = 'Y';
52:
53: cursor c_getMultipleMaps(p_obj_name in varchar2, p_instance in varchar2) IS
54: SELECT fk_physical_name
55: from edw_fact_flex_fk_maps a, edw_flex_seg_mappings b
56: where a.fact_short_name = p_obj_name
57: and a.dimension_short_name = b.dimension_short_name
58: and b.instance_code = p_instance
59: and a.enabled_flag = 'Y';