APPS.FEM_DATAX_LOADER_PKG dependencies on FEM_DIM_ATTRIBUTES_B

Line 908: fem_dim_attributes_b T,

904: SELECT count(*)
905: INTO v_count
906: FROM fem_ledgers_b B,
907: fem_ledgers_attr A,
908: fem_dim_attributes_b T,
909: fem_dimensions_b D,
910: fem_dim_attr_versions_b V
911: WHERE B.ledger_id = g_ledger_id
912: AND B.enabled_flag = 'Y'

Line 969: fem_dim_attributes_b T,

965: SELECT count(*)
966: INTO v_count
967: FROM fem_datasets_b B,
968: fem_datasets_attr A,
969: fem_dim_attributes_b T,
970: fem_dimensions_b D,
971: fem_dim_attr_versions_b V
972: WHERE B.dataset_code = g_dataset_cd
973: AND B.enabled_flag = 'Y'

Line 1040: (SELECT attribute_id FROM fem_dim_attributes_b

1036: fem_dim_attr_versions_b DV
1037: WHERE C.cal_period_id = g_cal_per_id
1038: AND C.dimension_group_id = G.dimension_group_id
1039: AND N.attribute_id =
1040: (SELECT attribute_id FROM fem_dim_attributes_b
1041: WHERE attribute_varchar_label = 'GL_PERIOD_NUM')
1042: AND N.version_id = NV.version_id
1043: AND N.cal_period_id = g_cal_per_id
1044: AND NV.default_version_flag = 'Y'

Line 1046: (SELECT attribute_id FROM fem_dim_attributes_b

1042: AND N.version_id = NV.version_id
1043: AND N.cal_period_id = g_cal_per_id
1044: AND NV.default_version_flag = 'Y'
1045: AND D.attribute_id =
1046: (SELECT attribute_id FROM fem_dim_attributes_b
1047: WHERE attribute_varchar_label = 'CAL_PERIOD_END_DATE')
1048: AND D.version_id = DV.version_id
1049: AND D.cal_period_id = g_cal_per_id
1050: AND DV.default_version_flag = 'Y';