APPS.OKL_LLA_UTIL_PVT dependencies on ARP_ADDR_LABEL_PKG

Line 972: SELECT SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL,HL.ADDRESS1,HL.ADDRESS2,HL.ADDRESS3,

968: FROM okc_k_headers_all_b
969: WHERE ID = p_khr_id;
970:
971: CURSOR l_get_booked_Astloc_csr IS
972: SELECT SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL,HL.ADDRESS1,HL.ADDRESS2,HL.ADDRESS3,
973: HL.ADDRESS4,HL.CITY,HL.COUNTY,HL.STATE,HL.PROVINCE,HL.POSTAL_CODE,NULL,HL.COUNTRY,
974: NULL, NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1),1,80) DESCRIPTION
975: FROM HZ_LOCATIONS HL,
976: CSI_ITEM_INSTANCES CSI,

Line 998: SELECT SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL,HL.ADDRESS1,HL.ADDRESS2,HL.ADDRESS3,

994: AND CIM.JTOT_OBJECT1_CODE = 'OKX_IB_ITEM'
995: AND CSI.INSTALL_LOCATION_ID = HL.LOCATION_ID
996: AND CSI.INSTALL_LOCATION_TYPE_CODE = 'HZ_LOCATIONS'
997: UNION
998: SELECT SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL,HL.ADDRESS1,HL.ADDRESS2,HL.ADDRESS3,
999: HL.ADDRESS4,HL.CITY,HL.COUNTY,HL.STATE,HL.PROVINCE,HL.POSTAL_CODE,NULL,HL.COUNTRY,
1000: NULL, NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1),1,80) DESCRIPTION
1001: FROM HZ_LOCATIONS HL,
1002: HZ_PARTY_SITES HPS,