APPS.FEM_GL_POST_PROCESS_PKG dependencies on FEM_DIM_ATTR_VERSIONS_B

Line 22: pv_dim_attr_ver_id fem_dim_attr_versions_b.version_id%TYPE;

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:
26: pv_obj_type_cd fem_object_catalog_b.object_type_code%TYPE;

Line 2987: fem_dim_attr_versions_b v

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'));
2991:

Line 3014: fem_dim_attr_versions_b v

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'));
3018:

Line 3041: fem_dim_attr_versions_b v

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'));
3045:

Line 4691: fem_dim_attr_versions_b fdavb,

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'
4695: AND fdb.dimension_id = fdab.dimension_id

Line 5596: , FEM_DIM_ATTR_VERSIONS_B yearV

5592: WHERE EFFECTIVE_PERIOD_NUM IN
5593: (SELECT DISTINCT per.EFFECTIVE_PERIOD_NUM
5594: FROM FEM_DL_DIMENSIONS dl
5595: , FEM_CAL_PERIODS_ATTR year
5596: , FEM_DIM_ATTR_VERSIONS_B yearV
5597: , GL_PERIOD_STATUSES per
5598: WHERE dl.LEDGER_ID = pv_ledger_id
5599: AND dl.DATASET_CODE <> pv_dataset_code
5600: AND dl.SOURCE_SYSTEM_CODE = pv_gl_source_system_code