eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GCS_HIERARCHIES_PKG dependencies on FEM_DATASETS_ATTR

Line 2236: fem_datasets_attr fda

2232: FROM gcs_data_type_codes_b gdtcb,
2233: gcs_data_type_codes_tl gdtctl,
2234: fem_dim_attributes_b fdab,
2235: fem_dim_attr_versions_b fdavb,
2236: fem_datasets_attr fda
2237: WHERE gdtcb.source_dataset_code = fda.dataset_code
2238: AND gdtcb.data_type_id = gdtctl.data_type_id
2239: AND gdtctl.language = userenv('LANG')
2240: AND fda.attribute_id = fdab.attribute_id

Line 2251: FROM fem_datasets_attr fda,

2247: -- If the source dataset is a budget or encumbrance, get the budget or encumbrance type id of the source dataset
2248: IF l_fem_balance_type = 'BUDGET' THEN
2249: SELECT fda.dim_attribute_numeric_member
2250: INTO l_budget_id
2251: FROM fem_datasets_attr fda,
2252: fem_dim_attributes_b fdab,
2253: fem_dim_attr_versions_b fdavb
2254: WHERE fda.attribute_id = fdab.attribute_id
2255: AND fdab.attribute_id = fdavb.attribute_id

Line 2265: FROM fem_datasets_attr fda,

2261:
2262: IF l_fem_balance_type = 'ENCUMBRANCE' THEN
2263: SELECT fda.dim_attribute_numeric_member
2264: INTO l_encumbrance_type_id
2265: FROM fem_datasets_attr fda,
2266: fem_dim_attributes_b fdab,
2267: fem_dim_attr_versions_b fdavb
2268: WHERE fda.attribute_id = fdab.attribute_id
2269: AND fdab.attribute_id = fdavb.attribute_id

Line 2438: fem_datasets_attr fda

2434: FROM gcs_data_type_codes_b gdtcb,
2435: gcs_data_type_codes_tl gdtctl,
2436: fem_dim_attributes_b fdab,
2437: fem_dim_attr_versions_b fdavb,
2438: fem_datasets_attr fda
2439: WHERE gdtcb.source_dataset_code = fda.dataset_code
2440: AND gdtcb.data_type_id = gdtctl.data_type_id
2441: AND gdtctl.language = userenv('LANG')
2442: AND fda.attribute_id = fdab.attribute_id

Line 2466: FROM fem_datasets_attr fda,

2462: -- If the source dataset is a budget or encumbrance, get the budget or encumbrance type id of the source dataset
2463: IF l_fem_balance_type = 'BUDGET' THEN
2464: SELECT fda.dim_attribute_numeric_member
2465: INTO l_budget_id
2466: FROM fem_datasets_attr fda,
2467: fem_dim_attributes_b fdab,
2468: fem_dim_attr_versions_b fdavb
2469: WHERE fda.attribute_id = fdab.attribute_id
2470: AND fdab.attribute_id = fdavb.attribute_id

Line 2480: FROM fem_datasets_attr fda,

2476:
2477: IF l_fem_balance_type = 'ENCUMBRANCE' THEN
2478: SELECT fda.dim_attribute_numeric_member
2479: INTO l_encumbrance_type_id
2480: FROM fem_datasets_attr fda,
2481: fem_dim_attributes_b fdab,
2482: fem_dim_attr_versions_b fdavb
2483: WHERE fda.attribute_id = fdab.attribute_id
2484: AND fdab.attribute_id = fdavb.attribute_id