APPS.OKL_DEAL_ASSET_PVT dependencies on ARP_ADDR_LABEL_PKG

Line 795: SELECT SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,

791:
792: c_ib_line_rec c_ib_line%ROWTYPE;
793:
794: CURSOR c_install_site(p_party_site_use_id NUMBER) IS
795: SELECT SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,
796: hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,
797: null, null,null,null,null,null,null,'n','n',80,1,1),1,80) party_site_name
798: FROM hz_locations hl,
799: hz_party_sites hps,

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

811: -- Passed p_clev_fin_id to cursor to get the install site name
812:
813: CURSOR c_install_site_active(p_chr_id NUMBER, p_clev_fin_id NUMBER) IS
814: select cle_ib.id clev_ib_id,
815: substr(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,
816: hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,
817: hl.postal_code,null,hl.country,null, null,null,null,null,null,
818: null,'n','n',80,1,1),1,80) party_site_name
819: from hz_locations hl,

Line 1081: SELECT SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,

1077: )
1078: RETURN VARCHAR2
1079: IS
1080: CURSOR c_party_site_name(p_site_use_id NUMBER) IS
1081: SELECT SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,
1082: hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,
1083: null, null,null,null,null,null,null,'n','n',80,1,1),1,80) ship_to_site_name
1084: FROM hz_locations hl,
1085: hz_party_sites hps,