APPS.OKL_DEAL_ASSET_PVT dependencies on ARP_ADDR_LABEL_PKG

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

749:
750: c_ib_line_rec c_ib_line%ROWTYPE;
751:
752: CURSOR c_install_site(p_party_site_use_id NUMBER) IS
753: SELECT SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,
754: hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,
755: null, null,null,null,null,null,null,'n','n',80,1,1),1,80) party_site_name
756: FROM hz_locations hl,
757: hz_party_sites hps,

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

765: -- gboomina added - Start
766: -- This cursor is used to get Install Site from CSI_ITEM_INSTANCES for Active Contract
767: CURSOR c_install_site_active(p_chr_id NUMBER) IS
768: select cle_ib.id clev_ib_id,
769: substr(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,
770: hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,
771: hl.postal_code,null,hl.country,null, null,null,null,null,null,
772: null,'n','n',80,1,1),1,80) party_site_name
773: from hz_locations hl,

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

1026: )
1027: RETURN VARCHAR2
1028: IS
1029: CURSOR c_party_site_name(p_site_use_id NUMBER) IS
1030: SELECT SUBSTR(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,
1031: hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,
1032: null, null,null,null,null,null,null,'n','n',80,1,1),1,80) ship_to_site_name
1033: FROM hz_locations hl,
1034: hz_party_sites hps,