APPS.HZ_PARTY_SITE_BO_PUB dependencies on HZ_LOCATIONS

Line 740: FROM HZ_PARTY_SITES ps, HZ_LOCATIONS loc

736: l_sms_objs HZ_SMS_CP_BO_TBL;
737:
738: CURSOR get_ovn(l_ps_id NUMBER) IS
739: SELECT ps.object_version_number, loc.object_version_number, ps.party_id, loc.location_id
740: FROM HZ_PARTY_SITES ps, HZ_LOCATIONS loc
741: WHERE ps.party_site_id = l_ps_id
742: AND ps.location_id = loc.location_id
743: AND ps.status in ('A','I');
744:

Line 1403: Location Y N HZ_LOCATIONS

1399: the Get procedure returns all records for the particular party site from these TCA entity tables:
1400:
1401: Embedded TCA Entity Mandatory Multiple TCA Table Entities
1402:
1403: Location Y N HZ_LOCATIONS
1404: Party Site Y N HZ_PARTY_SITES
1405: Party Site Use N Y HZ_PARTY_SITE_USES
1406: Contact Preference N Y HZ_CONTACT_PREFERENCES
1407: */