752: CURSOR c_install_site(p_party_site_use_id NUMBER) IS
753: SELECT SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,
754: hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,
755: null, null,null,null,null,null,null,'n','n',80,1,1),1,80) party_site_name
756: FROM hz_locations hl,
757: hz_party_sites hps,
758: hz_party_site_uses hpu
759: WHERE hpu.party_site_use_id = p_party_site_use_id
760: AND hps.party_site_id = hpu.party_site_id
769: substr(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,
770: hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,
771: hl.postal_code,null,hl.country,null, null,null,null,null,null,
772: null,'n','n',80,1,1),1,80) party_site_name
773: from hz_locations hl,
774: hz_party_sites hps,
775: csi_item_instances csi,
776: okc_k_items cim_ib,
777: okc_line_styles_b lse_ib,
1029: CURSOR c_party_site_name(p_site_use_id NUMBER) IS
1030: SELECT SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,
1031: hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,
1032: null, null,null,null,null,null,null,'n','n',80,1,1),1,80) ship_to_site_name
1033: FROM hz_locations hl,
1034: hz_party_sites hps,
1035: hz_cust_acct_sites_all cas,
1036: hz_cust_site_uses_all csu
1037: WHERE csu.site_use_id = p_site_use_id