APPS.OKL_ASSET_SUBSIDY_PVT dependencies on HZ_LOCATIONS

Line 1241: from hz_locations loc,

1237: /*
1238: cursor l_terr_csr (p_subsidy_id in number,
1239: p_asset_cle_id in number) is
1240: select 'Y'
1241: from hz_locations loc,
1242: hz_party_sites hzps,
1243: hz_party_site_uses hzpsu,
1244: okl_txl_itm_insts iti,
1245: --csi_item_instances csii,

Line 1839: from hz_locations loc,

1835: --cursor to check territory
1836: cursor l_terr_csr (p_subsidy_id in number,
1837: p_install_site_use_id in number) is
1838: select 'Y'
1839: from hz_locations loc,
1840: hz_party_sites hzps,
1841: hz_party_site_uses hzpsu,
1842: okl_subsidy_criteria suc
1843: Where hzpsu.party_site_use_id = p_install_site_use_id

Line 2357: from hz_locations loc,

2353: --cursor to check territory
2354: /* cursor l_terr_csr (p_subsidy_id in number,
2355: p_install_site_use_id in number) is
2356: select 'Y'
2357: from hz_locations loc,
2358: hz_party_sites hzps,
2359: hz_party_site_uses hzpsu,
2360: okl_subsidy_criteria suc
2361: Where hzpsu.party_site_use_id = p_install_site_use_id