APPS.FEM_GL_POST_PROCESS_PKG dependencies on FEM_DIM_ATTRIBUTES_B

Line 21: pv_dim_attr_id fem_dim_attributes_b.attribute_id%TYPE;

17: pv_proc_name VARCHAR2(30);
18:
19: pv_API_return_code NUMBER;
20:
21: pv_dim_attr_id fem_dim_attributes_b.attribute_id%TYPE;
22: pv_dim_attr_ver_id fem_dim_attr_versions_b.version_id%TYPE;
23: pv_attr_label fem_dim_attributes_b.attribute_varchar_label%TYPE;
24: pv_dim_name fem_dimensions_tl.dimension_name%TYPE;
25:

Line 23: pv_attr_label fem_dim_attributes_b.attribute_varchar_label%TYPE;

19: pv_API_return_code NUMBER;
20:
21: pv_dim_attr_id fem_dim_attributes_b.attribute_id%TYPE;
22: pv_dim_attr_ver_id fem_dim_attr_versions_b.version_id%TYPE;
23: pv_attr_label fem_dim_attributes_b.attribute_varchar_label%TYPE;
24: pv_dim_name fem_dimensions_tl.dimension_name%TYPE;
25:
26: pv_obj_type_cd fem_object_catalog_b.object_type_code%TYPE;
27: pv_cal_per_calendar_id fem_cal_periods_b.calendar_id%TYPE;

Line 2986: FROM fem_dim_attributes_b a,

2982: FROM fem_datasets_attr
2983: WHERE dataset_code = r.output_dataset_code
2984: AND (attribute_id, version_id) =
2985: (SELECT a.attribute_id, v.version_id
2986: FROM fem_dim_attributes_b a,
2987: fem_dim_attr_versions_b v
2988: WHERE a.attribute_varchar_label = 'DATASET_BALANCE_TYPE_CODE'
2989: AND v.attribute_id = a.attribute_id
2990: and v.default_version_flag = 'Y'));

Line 3013: FROM fem_dim_attributes_b a,

3009: FROM fem_datasets_attr
3010: WHERE dataset_code = r.output_dataset_code
3011: AND (attribute_id, version_id) =
3012: (SELECT a.attribute_id, v.version_id
3013: FROM fem_dim_attributes_b a,
3014: fem_dim_attr_versions_b v
3015: WHERE a.attribute_varchar_label = 'BUDGET_ID'
3016: AND v.attribute_id = a.attribute_id
3017: and v.default_version_flag = 'Y'));

Line 3040: FROM fem_dim_attributes_b a,

3036: FROM fem_datasets_attr
3037: WHERE dataset_code = r.output_dataset_code
3038: AND (attribute_id, version_id) =
3039: (SELECT a.attribute_id, v.version_id
3040: FROM fem_dim_attributes_b a,
3041: fem_dim_attr_versions_b v
3042: WHERE a.attribute_varchar_label = 'ENCUMBRANCE_TYPE_ID'
3043: AND v.attribute_id = a.attribute_id
3044: and v.default_version_flag = 'Y'));

Line 4690: fem_dim_attributes_b fdab,

4686: -- Bug 4294018 hkaniven start - Count the no of 'SIGN' attribute rows
4687: SELECT COUNT(*)
4688: INTO v_count
4689: FROM fem_dimensions_b fdb,
4690: fem_dim_attributes_b fdab,
4691: fem_dim_attr_versions_b fdavb,
4692: fem_ext_acct_types_attr feata
4693: WHERE fdb.dimension_varchar_label = 'EXTENDED_ACCOUNT_TYPE'
4694: AND fdab.attribute_varchar_label = 'SIGN'

Line 5607: FROM FEM_DIM_ATTRIBUTES_B

5603: AND dl.BALANCE_TYPE_CODE = 'ACTUAL'
5604: AND year.CAL_PERIOD_ID = dl.CAL_PERIOD_ID
5605: AND year.ATTRIBUTE_ID =
5606: (SELECT ATTRIBUTE_ID
5607: FROM FEM_DIM_ATTRIBUTES_B
5608: WHERE ATTRIBUTE_VARCHAR_LABEL = 'ACCOUNTING_YEAR')
5609: AND year.ATTRIBUTE_ID = yearV.ATTRIBUTE_ID
5610: AND year.VERSION_ID = yearV.VERSION_ID
5611: AND yearV.DEFAULT_VERSION_FLAG = 'Y'