APPS.HR_LEI_BUS dependencies on HR_LOCATION_INFO_TYPES

Line 199: l_active_inactive_flag HR_LOCATION_INFO_TYPES.ACTIVE_INACTIVE_FLAG%TYPE;

195: --
196: -- {End Of Comments}
197: -- ----------------------------------------------------------------------------
198: l_proc varchar2(72) := g_package||'chk_location_info_type';
199: l_active_inactive_flag HR_LOCATION_INFO_TYPES.ACTIVE_INACTIVE_FLAG%TYPE;
200: l_inactive_type exception;
201: --
202: CURSOR c_info_type IS
203: SELECT lit.multiple_occurences_flag

Line 205: FROM hr_location_info_types lit

201: --
202: CURSOR c_info_type IS
203: SELECT lit.multiple_occurences_flag
204: ,lit.active_inactive_flag
205: FROM hr_location_info_types lit
206: WHERE lit.information_type = p_information_type
207: ;
208: --
209: Begin

Line 677: l_multiple_occurences_flag hr_location_info_types.multiple_occurences_flag%type;

673: -- ----------------------------------------------------------------------------
674: Procedure insert_validate(p_rec in hr_lei_shd.g_rec_type) is
675: --
676: l_proc varchar2(72) := g_package||'insert_validate';
677: l_multiple_occurences_flag hr_location_info_types.multiple_occurences_flag%type;
678: --
679: -- bug 6329528
680: --
681: /*