DBA Data[Home] [Help]

APPS.HR_OPT_BUS dependencies on HR_KI_OPTION_TYPES

Line 119: -- This procedure ensures option_type_id is present in hr_ki_option_types

115: -- ----------------------------------------------------------------------------
116: -- {Start Of Comments}
117: --
118: -- Description:
119: -- This procedure ensures option_type_id is present in hr_ki_option_types
120: -- and it is mandatory.
121: -- Pre Conditions:
122: -- g_old_rec has been populated with details of the values currently in
123: -- the database.

Line 143: from hr_ki_option_types

139: l_proc varchar2(72) := g_package || 'CHK_OPTION_TYPE_ID';
140: l_key varchar2(30) ;
141: cursor csr_name is
142: select option_type_id
143: from hr_ki_option_types
144: where option_type_id = p_option_type_id;
145:
146: --
147: Begin