DBA Data[Home] [Help]

APPS.HXC_TIMECARD_PROPERTIES dependencies on HXC_ALIAS_TYPES

Line 804: from hxc_alias_types ty, hxc_alias_definitions ad

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;

Line 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);

Line 835: l_alias_reference hxc_alias_types.reference_object%type;

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