APPS.HXC_ALIAS_UTILITY dependencies on HXC_ALIAS_VALUES

Line 769: from hxc_alias_values

765: ,attribute27
766: ,attribute28
767: ,attribute29
768: ,attribute30
769: from hxc_alias_values
770: where alias_value_id = p_alias_value_id;
771:
772: l_alias_attribute_value VARCHAR2(150);
773:

Line 777: -- of hxc_alias_values, then following the segment name, we will put it into

773:
774: BEGIN
775:
776: -- following the p_component_type we need to pick up the right information
777: -- of hxc_alias_values, then following the segment name, we will put it into
778: -- the right segment in p_alias_val_att_to_match_row
779:
780: IF NOT g_alias_tab.EXISTS(to_char(p_alias_value_id))
781: THEN

Line 2895: from hxc_alias_values

2891:
2892: begin
2893: select alias_definition_id
2894: into l_alias_definition_id
2895: from hxc_alias_values
2896: where alias_value_id = p_alias_value_id;
2897: EXCEPTION
2898: WHEN OTHERS
2899: THEN

Line 3362: 'from hxc_alias_values_tl havtl,'||

3358: -- mutilple case here
3359: IF l_reference_object = 'ELEMENTS_EXPENDITURE_SLF' THEN
3360:
3361: x_select := 'select distinct(havtl.alias_value_name) display_value, havtl.alias_value_id id_value '||
3362: 'from hxc_alias_values_tl havtl,'||
3363: 'hxc_alias_values hav,'||
3364: 'hxc_alias_definitions had,'||
3365: 'pa_online_expenditure_types_v pa,'||
3366: 'PAY_ELEMENT_TYPES_F_TL ELEMENTTL, '||

Line 3363: 'hxc_alias_values hav,'||

3359: IF l_reference_object = 'ELEMENTS_EXPENDITURE_SLF' THEN
3360:
3361: x_select := 'select distinct(havtl.alias_value_name) display_value, havtl.alias_value_id id_value '||
3362: 'from hxc_alias_values_tl havtl,'||
3363: 'hxc_alias_values hav,'||
3364: 'hxc_alias_definitions had,'||
3365: 'pa_online_expenditure_types_v pa,'||
3366: 'PAY_ELEMENT_TYPES_F_TL ELEMENTTL, '||
3367: 'PAY_ELEMENT_TYPES_F ELEMENT, '||

Line 3448: 'from hxc_alias_values hav, '||

3444: ELSIF l_reference_object = 'PAYROLL_ELEMENTS' THEN
3445:
3446: x_select := 'select distinct(havt.alias_value_name) Display_Value,'||
3447: ' hav.alias_value_id id_value '||
3448: 'from hxc_alias_values hav, '||
3449: ' hxc_alias_values_tl havt, '||
3450: ' hxc_alias_definitions had, '||
3451: ' PAY_ELEMENT_TYPES_F_TL ELEMENTTL, '||
3452: ' PAY_ELEMENT_TYPES_F ELEMENT, '||

Line 3449: ' hxc_alias_values_tl havt, '||

3445:
3446: x_select := 'select distinct(havt.alias_value_name) Display_Value,'||
3447: ' hav.alias_value_id id_value '||
3448: 'from hxc_alias_values hav, '||
3449: ' hxc_alias_values_tl havt, '||
3450: ' hxc_alias_definitions had, '||
3451: ' PAY_ELEMENT_TYPES_F_TL ELEMENTTL, '||
3452: ' PAY_ELEMENT_TYPES_F ELEMENT, '||
3453: ' PAY_ELEMENT_CLASSIFICATIONS_TL CLASSIFICATIONTL, '||

Line 3530: 'from hxc_alias_values hav, '||

3526: ELSE
3527:
3528: x_select := 'select havt.alias_value_name Display_Value,'||
3529: ' hav.alias_value_id id_value '||
3530: 'from hxc_alias_values hav, '||
3531: ' hxc_alias_values_tl havt, '||
3532: ' hxc_alias_definitions had '||
3533: 'where hav.enabled_flag=''Y'' '||
3534: ' and had.alias_definition_id = hav.alias_definition_id '||

Line 3531: ' hxc_alias_values_tl havt, '||

3527:
3528: x_select := 'select havt.alias_value_name Display_Value,'||
3529: ' hav.alias_value_id id_value '||
3530: 'from hxc_alias_values hav, '||
3531: ' hxc_alias_values_tl havt, '||
3532: ' hxc_alias_definitions had '||
3533: 'where hav.enabled_flag=''Y'' '||
3534: ' and had.alias_definition_id = hav.alias_definition_id '||
3535: ' and had.alias_definition_id = '||p_alias_definition_id||

Line 3694: from hxc_alias_values

3690: BEGIN
3691:
3692: select attribute3
3693: into l_sfl
3694: from hxc_alias_values
3695: where alias_value_id = p_alias_value_id;
3696:
3697: RETURN l_sfl;
3698: