DBA Data[Home] [Help]

APPS.OKL_ASSET_SUBSIDY_PVT dependencies on HZ_PARTY_SITE_USES

Line 1243: hz_party_site_uses hzpsu,

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,
1246: --okc_k_items cim_ib,
1247: okc_k_lines_b cle_ib,

Line 1841: hz_party_site_uses hzpsu,

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
1844: And hzps.party_site_id = hzpsu.party_site_id
1845: And loc.location_id = hzps.location_id

Line 2359: hz_party_site_uses hzpsu,

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
2362: And hzps.party_site_id = hzpsu.party_site_id
2363: And loc.location_id = hzps.location_id