APPS.OKL_DEAL_ASSET_PVT dependencies on HZ_LOCATIONS

Line 798: FROM hz_locations hl,

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,
800: hz_party_site_uses hpu
801: WHERE hpu.party_site_use_id = p_party_site_use_id
802: AND hps.party_site_id = hpu.party_site_id

Line 819: from hz_locations hl,

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,
820: hz_party_sites hps,
821: csi_item_instances csi,
822: okc_k_items cim_ib,
823: okc_line_styles_b lse_ib,

Line 1084: FROM hz_locations hl,

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,
1086: hz_cust_acct_sites_all cas,
1087: hz_cust_site_uses_all csu
1088: WHERE csu.site_use_id = p_site_use_id