APPS.OKL_SSC_WF dependencies on ARP_ADDR_LABEL_PKG

Line 2140: ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL,L.ADDRESS1,L.ADDRESS2,L.ADDRESS3,

2136: --rkuttiya added the below cursor for bug#6523600
2137: CURSOR current_billing_info(p_contract_id IN NUMBER) IS
2138: SELECT contract.contract_number contract_number,
2139: cs.location bill_to_site,
2140: ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL,L.ADDRESS1,L.ADDRESS2,L.ADDRESS3,
2141: L.ADDRESS4,L.CITY,L.COUNTY,L.STATE,L.PROVINCE,L.POSTAL_CODE,NULL,L.COUNTRY,NULL,
2142: NULL,NULL,NULL,NULL,NULL,NULL,'N','N',300,1,1) bill_to_address
2143: FROM hz_cust_site_uses_all cs,
2144: hz_cust_acct_sites_all ca,

Line 2185: ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL,L.ADDRESS1,L.ADDRESS2,L.ADDRESS3,

2181: where id1= p_billing_site_id; */
2182:
2183: CURSOR new_billing_info(p_billing_site_id IN VARCHAR2) IS
2184: SELECT CS.LOCATION BILL_TO_SITE,
2185: ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL,L.ADDRESS1,L.ADDRESS2,L.ADDRESS3,
2186: L.ADDRESS4,L.CITY,L.COUNTY,L.STATE,L.PROVINCE,L.POSTAL_CODE,NULL,L.COUNTRY,NULL,
2187: NULL,NULL,NULL,NULL,NULL,NULL,'N','N',300,1,1) BILL_TO_ADDRESS
2188: FROM HZ_CUST_SITE_USES_ALL CS,
2189: HZ_CUST_ACCT_SITES_ALL CA,