APPS.GCS_ADJ_APPROVAL_WF_PKG dependencies on GCS_HIERARCHIES_TL

Line 241: l_hierarchy_name gcs_hierarchies_tl.hierarchy_name%type;

237: l_submitted_by gcs_entry_headers.created_by%type;
238: l_itemkey VARCHAR2(80);
239:
240: l_entity_name fem_entities_tl.entity_name%type;
241: l_hierarchy_name gcs_hierarchies_tl.hierarchy_name%type;
242: l_period_name fem_cal_periods_tl.cal_period_name%type;
243:
244: Cursor c_entity_details IS
245: Select Entity_name

Line 252: From gcs_hierarchies_tl

248: and language = userenv('LANG');
249:
250: Cursor c_hierarchy_details IS
251: Select hierarchy_name
252: From gcs_hierarchies_tl
253: Where hierarchy_id = l_hierarchy_id
254: and language = userenv('LANG');
255:
256: Cursor c_period_details IS