APPS.GCS_WF_NTF_PKG dependencies on FEM_ENTITIES_ATTR

Line 110: --fem_entities_attr fea_cons,

106: gcs_cons_eng_runs gcer,
107: gcs_data_type_codes_b gdtcb,
108: gcs_data_type_codes_tl gdtct,
109: fem_cal_periods_tl fcpt,
110: --fem_entities_attr fea_cons,
111: fem_entities_attr fea_child
112: WHERE gcerd.run_detail_id = p_cons_detail_id
113: AND gcerd.consolidation_entity_id = fet_cons.entity_id
114: AND gcerd.child_entity_id = fet_child.entity_id (+)

Line 111: fem_entities_attr fea_child

107: gcs_data_type_codes_b gdtcb,
108: gcs_data_type_codes_tl gdtct,
109: fem_cal_periods_tl fcpt,
110: --fem_entities_attr fea_cons,
111: fem_entities_attr fea_child
112: WHERE gcerd.run_detail_id = p_cons_detail_id
113: AND gcerd.consolidation_entity_id = fet_cons.entity_id
114: AND gcerd.child_entity_id = fet_child.entity_id (+)
115: AND gcerd.contra_child_entity_id = fet_counter.entity_id (+)

Line 164: FROM fem_entities_attr fea_counter

160: BEGIN
161: -- Get contact for counter entity
162: SELECT fea_counter.varchar_assign_value
163: INTO l_counter_recipient
164: FROM fem_entities_attr fea_counter
165: WHERE fea_counter.entity_id = l_counter_entity_id
166: AND fea_counter.attribute_id = l_entity_contact_attr
167: AND fea_counter.version_id = l_entity_contact_ver;
168: -- Create ad-hoc role

Line 297: fem_entities_attr fea_cons,

293: gcs_hierarchies_tl ght,
294: gcs_cons_eng_runs gcer,
295: gcs_data_type_codes_b gdtcb,
296: gcs_data_type_codes_tl gdtct,
297: fem_entities_attr fea_cons,
298: fem_cal_periods_tl fcpt
299: WHERE p_run_name = gcer.run_name
300: AND gcer.run_entity_id = p_cons_entity_id
301: AND gcer.run_entity_id = fet_cons.entity_id

Line 418: fem_entities_attr fea_cons

414: gcs_cons_eng_runs gcer,
415: gcs_data_type_codes_b gdtcb,
416: gcs_data_type_codes_tl gdtct,
417: fem_cal_periods_tl fcpt,
418: fem_entities_attr fea_cons
419: WHERE p_run_name = gcer.run_name
420: AND gcer.run_entity_id = p_cons_entity_id
421: AND gcer.run_entity_id = fet_cons.entity_id
422: AND gcer.hierarchy_id = ght.hierarchy_id