DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_UTILITIES dependencies on HXC_ALIAS_VALUES

Line 4092: p_id IN hxc_alias_values.alias_value_id%TYPE

4088: p_alias_value_id IN VARCHAR2
4089: )
4090: RETURN VARCHAR2 IS
4091: CURSOR c_alias_to_pa_info (
4092: p_id IN hxc_alias_values.alias_value_id%TYPE
4093: ) IS
4094: SELECT attribute2
4095: FROM hxc_alias_values
4096: WHERE alias_value_id = p_id AND attribute_category = 'ELEMENTS_EXPENDITURE_SLF';

Line 4095: FROM hxc_alias_values

4091: CURSOR c_alias_to_pa_info (
4092: p_id IN hxc_alias_values.alias_value_id%TYPE
4093: ) IS
4094: SELECT attribute2
4095: FROM hxc_alias_values
4096: WHERE alias_value_id = p_id AND attribute_category = 'ELEMENTS_EXPENDITURE_SLF';
4097:
4098: l_expenditure_type VARCHAR2 (250);
4099: BEGIN

Line 5833: FROM hxc_alias_values hav,

5829: ) IS
5830:
5831: SELECT hav.alias_value_id
5832:
5833: FROM hxc_alias_values hav,
5834: hxc_alias_definitions had,
5835: hxc_alias_types hat
5836:
5837: WHERE hav.attribute1=to_char(p_element_type_id) and