APPS.OKL_LLA_UTIL_PVT dependencies on ARP_ADDR_LABEL_PKG

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

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

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

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