APPS.GCS_PURGE_PKG dependencies on FEM_ENTITIES_TL

Line 168: fem_entities_tl fem

164: p_end_rowid ROWID
165: ) IS
166: SELECT DISTINCT run_name, run_entity_id, entity_name
167: FROM gcs_cons_eng_runs gcer,
168: fem_entities_tl fem
169: WHERE gcer.run_entity_id = fem.entity_id
170: AND gcer.hierarchy_id = p_consolidation_hierarchy
171: AND gcer.cal_period_id = p_cal_period_id
172: AND gcer.balance_type_code = p_balance_type_code

Line 401: FROM fem_entities_tl fem

397: DELETE FROM gcs_entry_headers WHERE entry_id = l_purge_entry_id_rec(j).entry_id;
398: -- To get the Child entity name
399: SELECT entity_name
400: INTO l_entity_name
401: FROM fem_entities_tl fem
402: WHERE fem.entity_id = l_purge_entry_id_rec(j).child_entity_id
403: AND fem.language = userenv('lang');
404: -- To print purged informatin into log file
405: fnd_file.put_line(fnd_file.log,'| '||rpad(l_entity_name,35,' ')||'| '||