909: ,hl.room
910: ,hl.postal_plus4_code
911: FROM okc_k_party_roles_b opr
912: ,hz_parties hp
913: ,hz_party_sites hps
914: ,hz_locations hl
915: ,hz_party_site_uses hpsu
916: WHERE opr.dnz_chr_id = cp_contract_id
917: AND opr.rle_code = 'GUARANTOR'
1372: ,hl.room
1373: ,hl.postal_plus4_code
1374: FROM hz_locations hl
1375: ,(SELECT location_id
1376: FROM hz_party_sites
1377: WHERE party_site_id = cp_location_id) hps
1378: WHERE hl.location_id = hps.location_id;
1379: BEGIN
1380: x_oiav_tbl.delete;