DBA Data[Home] [Help]

APPS.HXC_ABSENCE_TYPE_ALIAS dependencies on HXC_ALIAS_VALUES_TL

Line 292: FROM hxc_alias_values_tl havt,

288: BEGIN
289:
290: SELECT 'Y'
291: INTO p_alias_value_name_exists
292: FROM hxc_alias_values_tl havt,
293: hxc_alias_values hav
294: WHERE substr(havt.alias_value_name,1,instr(havt.alias_value_name,'(')-2)
295: = substr(l_alias_value_name,1,instr(havt.alias_value_name,'(')-2)
296: AND havt.alias_value_id = hav.alias_value_id

Line 311: FROM hxc_alias_values_tl havt,

307: SELECT hav.alias_value_id,
308: hav.object_version_number
309: INTO l_alias_value_id,
310: l_alias_value_id_ovn
311: FROM hxc_alias_values_tl havt,
312: hxc_alias_values hav
313: WHERE substr(havt.alias_value_name,1,instr(havt.alias_value_name,'(')-2)
314: = substr(l_alias_value_name,1,instr(havt.alias_value_name,'(')-2)
315: AND havt.alias_value_id = hav.alias_value_id