APPS.FEM_INTG_NEW_DIM_MEMBER_PKG dependencies on FEM_DIM_ATTR_VERSIONS_B

Line 114: FEM_DIM_ATTR_VERSIONS_B AV

110: FROM
111: FEM_NAT_ACCTS_B M,
112: FND_FLEX_VALUES V,
113: FEM_DIM_ATTRIBUTES_B A,
114: FEM_DIM_ATTR_VERSIONS_B AV
115: WHERE
116: M.VALUE_SET_ID = :b_driving_where_vs_id ||
117: :b_m_vs_id || :b_gt_dim_id AND
118: V.FLEX_VALUE_SET_ID = :b_flex_value_where_vs_id1 AND

Line 474: FEM_DIM_ATTR_VERSIONS_B AV' || v_gvsc_from;

470: END IF;
471:
472: v_from := v_driving_from || v_flex_value_from1 || v_flex_value_from2 || '
473: FEM_DIM_ATTRIBUTES_B A,
474: FEM_DIM_ATTR_VERSIONS_B AV' || v_gvsc_from;
475:
476: v_where := v_driving_where || v_flex_value_where1 || v_flex_value_where2 || ' AND
477: A.DIMENSION_ID = :b_a_dim_id AND
478: AV.ATTRIBUTE_ID = A.ATTRIBUTE_ID AND

Line 605: FEM_DIM_ATTR_VERSIONS_B AV' || v_gvsc_from;

601: v_from := '
602: ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_member_b_table_name || ' M,
603: FEM_INTG_DIM_MEMBERS_GT GT,' || v_flex_value_from1 || v_flex_value_from2 || '
604: FEM_DIM_ATTRIBUTES_B A,
605: FEM_DIM_ATTR_VERSIONS_B AV' || v_gvsc_from;
606:
607: v_where := '
608: M.VALUE_SET_ID = :b_driving_where_vs_id || :b_m_vs_id AND
609: GT.DIMENSION_ID = :b_gt_dim_id AND

Line 4739: fem_dim_attr_versions_b v

4735: ,v.version_id
4736: INTO v_ext_acct_type_attr_id
4737: ,v_ext_acct_type_ver_id
4738: FROM fem_dim_attributes_b a,
4739: fem_dim_attr_versions_b v
4740: WHERE a.dimension_id = 2
4741: AND a.attribute_varchar_label='EXTENDED_ACCOUNT_TYPE'
4742: AND v.attribute_id = a.attribute_id
4743: AND v.default_version_flag = 'Y';