APPS.OKS_RENEW_CONTRACT_PVT dependencies on ARP_ADDR_LABEL_PKG

Line 4568: SUBSTR(arp_addr_label_pkg.format_address(NULL,LCN.ADDRESS1,LCN.ADDRESS2,LCN.ADDRESS3,

4564: FROM CSI_SYSTEMS_TL T
4565: WHERE T.LANGUAGE = USERENV('LANG')
4566: UNION ALL
4567: SELECT 'OKX_PARTYSITE' TYPE, PSE.PARTY_SITE_ID ID1, '#' ID2, PSE.PARTY_SITE_NAME NAME,
4568: SUBSTR(arp_addr_label_pkg.format_address(NULL,LCN.ADDRESS1,LCN.ADDRESS2,LCN.ADDRESS3,
4569: LCN.ADDRESS4,LCN.CITY,LCN.COUNTY,LCN.STATE,LCN.PROVINCE,LCN.POSTAL_CODE,NULL,LCN.COUNTRY,
4570: NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1
4571: ),1,80) DESCRIPTION, NULL INV_ORG_ID
4572: FROM HZ_PARTY_SITES PSE,HZ_LOCATIONS LCN