APPS.OKL_SERVICE_INTEGRATION_PVT dependencies on ARP_ADDR_LABEL_PKG

Line 2339: substr(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,

2335: AND csi.instance_id = p_instance_id;
2336:
2337: CURSOR loc_detail_csr (p_location_id NUMBER) IS
2338: SELECT
2339: substr(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,
2340: hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,null,
2341: null,null,null,null,null,null,'n','n',80,1,1),1,80) loc_address
2342: FROM hz_locations hl
2343: WHERE hl.location_id = p_location_id;