800:
801: cursor c_ref_obj
802: (p_id in hxc_alias_definitions.alias_definition_id%type) is
803: select ty.reference_object
804: from hxc_alias_types ty, hxc_alias_definitions ad
805: where ad.alias_definition_id = p_id
806: and ty.alias_type_id = ad.alias_type_id;
807:
808: l_reference_object hxc_alias_types.reference_object%type;
804: from hxc_alias_types ty, hxc_alias_definitions ad
805: where ad.alias_definition_id = p_id
806: and ty.alias_type_id = ad.alias_type_id;
807:
808: l_reference_object hxc_alias_types.reference_object%type;
809:
810: begin
811:
812: open c_ref_obj(p_alias_definition_id);
831: ,p_date_to in date
832: ,p_props in out nocopy hxc_timecard_prop_table_type
833: ) is
834:
835: l_alias_reference hxc_alias_types.reference_object%type;
836: begin
837:
838: l_alias_reference := get_alias_reference_object(p_alias_definition_id);
839: if(l_alias_reference is not null) then