APPS.HXC_TIMECARD_PROPERTIES dependencies on HXC_ALIAS_TYPES

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;

Line 835: l_reference_object hxc_alias_types.reference_object%type;

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;
836:
837: begin
838:
839: open c_ref_obj(p_alias_definition_id);

Line 862: l_alias_reference hxc_alias_types.reference_object%type;

858: ,p_date_to in date
859: ,p_props in out nocopy hxc_timecard_prop_table_type
860: ) is
861:
862: l_alias_reference hxc_alias_types.reference_object%type;
863: begin
864:
865: l_alias_reference := get_alias_reference_object(p_alias_definition_id);
866: if(l_alias_reference is not null) then