DBA Data[Home] [Help]

APPS.POS_SBD_IBY_PKG dependencies on HZ_LOCATIONS

Line 656: l_obj_ver HZ_LOCATIONS.object_version_number%TYPE;

652: IS
653:
654: l_step number;
655: l_msg_count number;
656: l_obj_ver HZ_LOCATIONS.object_version_number%TYPE;
657: l_created_by_module HZ_PARTY_SITES.created_by_module%TYPE;
658: l_location_rec hz_location_v2pub.LOCATION_REC_TYPE;
659:
660: BEGIN

Line 676: into l_obj_ver, l_created_by_module from hz_locations

672: ' p_address1 ' || p_address1);
673: END IF;
674:
675: select object_version_number, created_by_module
676: into l_obj_ver, l_created_by_module from hz_locations
677: where location_id = p_location_id;
678:
679: l_step := 1;
680: