APPS.JG_ZZ_RGRH_PKG dependencies on HZ_PARTY_SITES

Line 66: where location_id = ( select location_id from hz_party_sites where party_site_id = site_id) ;

62: from xle_entity_profiles where legal_entity_id = P_legal_entity_id;
63: select issuing_authority_site_id into site_id from xle_registrations
64: where source_id= P_LEGAL_ENTITY_ID and source_table='XLE_ENTITY_PROFILES' and IDENTIFYING_FLAG='Y';
65: select SUBSTR(address1,1,30) || country into C_GR_TAX_AREA from hz_locations
66: where location_id = ( select location_id from hz_party_sites where party_site_id = site_id) ;
67: Exception
68: When NO_DATA_FOUND Then
69: null;
70: End;