APPS.HXC_TIMECARD_PROPERTIES dependencies on HXC_ALIAS_DEFINITIONS

Line 825: (p_alias_definition_id in hxc_alias_definitions.alias_definition_id%type)

821:
822: END get_personal_information;
823:
824: function get_alias_reference_object
825: (p_alias_definition_id in hxc_alias_definitions.alias_definition_id%type)
826: RETURN varchar2 is
827:
828: cursor c_ref_obj
829: (p_id in hxc_alias_definitions.alias_definition_id%type) is

Line 829: (p_id in hxc_alias_definitions.alias_definition_id%type) is

825: (p_alias_definition_id in hxc_alias_definitions.alias_definition_id%type)
826: RETURN varchar2 is
827:
828: cursor c_ref_obj
829: (p_id in hxc_alias_definitions.alias_definition_id%type) is
830: select ty.reference_object
831: from hxc_alias_types ty, hxc_alias_definitions ad
832: where ad.alias_definition_id = p_id
833: and ty.alias_type_id = ad.alias_type_id;

Line 831: from hxc_alias_types ty, hxc_alias_definitions ad

827:
828: cursor c_ref_obj
829: (p_id in hxc_alias_definitions.alias_definition_id%type) is
830: select ty.reference_object
831: from hxc_alias_types ty, hxc_alias_definitions ad
832: where ad.alias_definition_id = p_id
833: and ty.alias_type_id = ad.alias_type_id;
834:
835: l_reference_object hxc_alias_types.reference_object%type;