APPS.GCS_ADJ_APPROVAL_WF_PKG dependencies on FEM_CAL_PERIODS_TL

Line 242: l_period_name fem_cal_periods_tl.cal_period_name%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
246: From fem_entities_tl

Line 258: From fem_cal_periods_tl fctl

254: and language = userenv('LANG');
255:
256: Cursor c_period_details IS
257: Select fctl.cal_period_name
258: From fem_cal_periods_tl fctl
259: Where fctl.cal_period_id = l_start_cal_period_id
260: and fctl.language = USERENV('LANG');
261:
262: