APPS.JA_CN_CFS_IMA_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 77: l_org_name hr_all_organization_units_tl.name%type;

73: l_Application_Name FND_APPLICATION_TL.Application_Name%type;
74: l_Event_Class_Name xla_event_classes_TL.Name%type;
75: l_source_name Xla_Sources_tl.Name%type;
76: l_org_id ja_cn_cfs_item_mapping_lines.org_id%type;
77: l_org_name hr_all_organization_units_tl.name%type;
78: l_ac_value ja_cn_cfs_item_mapping_lines.ac_value%type;
79: l_detailed_cfs_item ja_cn_cfs_item_mapping_lines.detailed_cfs_item%type;
80: l_cash_flow_item_desc Fnd_Flex_Values_Tl.Description%type;
81: l_effective_start_date Ja_Cn_Cfs_Item_Mapping_lines.Effective_Start_Date%type;

Line 123: FROM Hr_All_Organization_Units_Tl

119:
120: --get organization name
121: CURSOR c_org_name is
122: SELECT NAME
123: FROM Hr_All_Organization_Units_Tl
124: WHERE Organization_Id = l_org_id
125: AND LANGUAGE = USERENV('LANG');
126:
127: --get the application name