DBA Data[Home] [Help]

APPS.GCS_DATASUB_WF_PKG dependencies on FEM_DATASETS_ATTR

Line 106: fem_datasets_attr fda,

102: fem_entities_b feb,
103: fem_ledgers_b flb,
104: gcs_entities_attr gea,
105: gcs_data_type_codes_b gdtcb,
106: fem_datasets_attr fda,
107: fem_cal_periods_attr fcpa
108: WHERE gdsd.load_id = p_load_id
109: AND gdsd.entity_id = feb.entity_id
110: AND feb.entity_id = gea.entity_id

Line 129: FROM fem_datasets_attr fda,

125: SELECT fb.budget_id,
126: fb.budget_display_code
127: INTO p_datasub_info.budget_id,
128: p_datasub_info.budget_display_code
129: FROM fem_datasets_attr fda,
130: fem_budgets_b fb
131: WHERE fda.dataset_code = p_datasub_info.dataset_code
132: AND fda.attribute_id = l_budget_attr
133: AND fda.version_id = l_budget_version

Line 141: FROM fem_datasets_attr fda,

137: SELECT fetb.encumbrance_type_id,
138: fetb.encumbrance_type_code
139: INTO p_datasub_info.encumbrance_type_id,
140: p_datasub_info.encumbrance_type_code
141: FROM fem_datasets_attr fda,
142: fem_encumbrance_types_b fetb
143: WHERE fda.dataset_code = p_datasub_info.dataset_code
144: AND fda.attribute_id = l_encumbrance_attr
145: AND fda.version_id = l_encumbrance_version