APPS.OKL_ASSET_SUBSIDY_PVT dependencies on HZ_LOCATIONS

Line 1258: from hz_locations loc,

1254: /*
1255: cursor l_terr_csr (p_subsidy_id in number,
1256: p_asset_cle_id in number) is
1257: select 'Y'
1258: from hz_locations loc,
1259: hz_party_sites hzps,
1260: hz_party_site_uses hzpsu,
1261: okl_txl_itm_insts iti,
1262: --csi_item_instances csii,

Line 1860: from hz_locations loc,

1856: --cursor to check territory
1857: cursor l_terr_csr (p_subsidy_id in number,
1858: p_install_site_use_id in number) is
1859: select 'Y'
1860: from hz_locations loc,
1861: hz_party_sites hzps,
1862: hz_party_site_uses hzpsu,
1863: okl_subsidy_criteria suc
1864: Where hzpsu.party_site_use_id = p_install_site_use_id

Line 2378: from hz_locations loc,

2374: --cursor to check territory
2375: /* cursor l_terr_csr (p_subsidy_id in number,
2376: p_install_site_use_id in number) is
2377: select 'Y'
2378: from hz_locations loc,
2379: hz_party_sites hzps,
2380: hz_party_site_uses hzpsu,
2381: okl_subsidy_criteria suc
2382: Where hzpsu.party_site_use_id = p_install_site_use_id