APPS.HXC_ALIAS_UTILITY dependencies on HXC_ALIAS_VALUES

Line 705: from hxc_alias_values

701: ,attribute27
702: ,attribute28
703: ,attribute29
704: ,attribute30
705: from hxc_alias_values
706: where alias_value_id = p_alias_value_id;
707:
708: l_alias_attribute_value VARCHAR2(150);
709:

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

709:
710: BEGIN
711:
712: -- following the p_component_type we need to pick up the right information
713: -- of hxc_alias_values, then following the segment name, we will put it into
714: -- the right segment in p_alias_val_att_to_match_row
715:
716: FOR c_alias_value_attribute in csr_alias_value_attribute LOOP
717: -- first we look for the attribute to find

Line 2579: from hxc_alias_values

2575:
2576: begin
2577: select alias_definition_id
2578: into l_alias_definition_id
2579: from hxc_alias_values
2580: where alias_value_id = p_alias_value_id;
2581: EXCEPTION
2582: WHEN OTHERS
2583: THEN

Line 3046: 'from hxc_alias_values_tl havtl,'||

3042: -- mutilple case here
3043: IF l_reference_object = 'ELEMENTS_EXPENDITURE_SLF' THEN
3044:
3045: x_select := 'select distinct(havtl.alias_value_name) display_value, havtl.alias_value_id id_value '||
3046: 'from hxc_alias_values_tl havtl,'||
3047: 'hxc_alias_values hav,'||
3048: 'hxc_alias_definitions had,'||
3049: 'pa_online_expenditure_types_v pa,'||
3050: 'PAY_ELEMENT_TYPES_F_TL ELEMENTTL, '||

Line 3047: 'hxc_alias_values hav,'||

3043: IF l_reference_object = 'ELEMENTS_EXPENDITURE_SLF' THEN
3044:
3045: x_select := 'select distinct(havtl.alias_value_name) display_value, havtl.alias_value_id id_value '||
3046: 'from hxc_alias_values_tl havtl,'||
3047: 'hxc_alias_values hav,'||
3048: 'hxc_alias_definitions had,'||
3049: 'pa_online_expenditure_types_v pa,'||
3050: 'PAY_ELEMENT_TYPES_F_TL ELEMENTTL, '||
3051: 'PAY_ELEMENT_TYPES_F ELEMENT, '||

Line 3132: 'from hxc_alias_values hav, '||

3128: ELSIF l_reference_object = 'PAYROLL_ELEMENTS' THEN
3129:
3130: x_select := 'select distinct(havt.alias_value_name) Display_Value,'||
3131: ' hav.alias_value_id id_value '||
3132: 'from hxc_alias_values hav, '||
3133: ' hxc_alias_values_tl havt, '||
3134: ' hxc_alias_definitions had, '||
3135: ' PAY_ELEMENT_TYPES_F_TL ELEMENTTL, '||
3136: ' PAY_ELEMENT_TYPES_F ELEMENT, '||

Line 3133: ' hxc_alias_values_tl havt, '||

3129:
3130: x_select := 'select distinct(havt.alias_value_name) Display_Value,'||
3131: ' hav.alias_value_id id_value '||
3132: 'from hxc_alias_values hav, '||
3133: ' hxc_alias_values_tl havt, '||
3134: ' hxc_alias_definitions had, '||
3135: ' PAY_ELEMENT_TYPES_F_TL ELEMENTTL, '||
3136: ' PAY_ELEMENT_TYPES_F ELEMENT, '||
3137: ' PAY_ELEMENT_CLASSIFICATIONS_TL CLASSIFICATIONTL, '||

Line 3214: 'from hxc_alias_values hav, '||

3210: ELSE
3211:
3212: x_select := 'select havt.alias_value_name Display_Value,'||
3213: ' hav.alias_value_id id_value '||
3214: 'from hxc_alias_values hav, '||
3215: ' hxc_alias_values_tl havt, '||
3216: ' hxc_alias_definitions had '||
3217: 'where hav.enabled_flag=''Y'' '||
3218: ' and had.alias_definition_id = hav.alias_definition_id '||

Line 3215: ' hxc_alias_values_tl havt, '||

3211:
3212: x_select := 'select havt.alias_value_name Display_Value,'||
3213: ' hav.alias_value_id id_value '||
3214: 'from hxc_alias_values hav, '||
3215: ' hxc_alias_values_tl havt, '||
3216: ' hxc_alias_definitions had '||
3217: 'where hav.enabled_flag=''Y'' '||
3218: ' and had.alias_definition_id = hav.alias_definition_id '||
3219: ' and had.alias_definition_id = '||p_alias_definition_id||

Line 3378: from hxc_alias_values

3374: BEGIN
3375:
3376: select attribute3
3377: into l_sfl
3378: from hxc_alias_values
3379: where alias_value_id = p_alias_value_id;
3380:
3381: RETURN l_sfl;
3382: