DBA Data[Home] [Help]

APPS.POS_SUPPLIER_ADDRESS_PKG dependencies on HZ_LOCATIONS

Line 660: l_obj_ver hz_locations.object_version_number%TYPE;

656: )
657: IS
658: l_party_site_rec hz_party_site_v2pub.party_site_rec_type;
659: l_location_rec hz_location_v2pub.location_rec_type;
660: l_obj_ver hz_locations.object_version_number%TYPE;
661:
662: CURSOR l_cur IS
663: SELECT object_version_number,location_id
664: from hz_locations

Line 664: from hz_locations

660: l_obj_ver hz_locations.object_version_number%TYPE;
661:
662: CURSOR l_cur IS
663: SELECT object_version_number,location_id
664: from hz_locations
665: where location_id =
666: (SELECT location_id
667: FROM hz_party_sites
668: WHERE party_site_id = p_party_site_id