DBA Data[Home] [Help]

APPS.OKL_ASSET_SUBSIDY_PVT dependencies on HZ_PARTY_SITE_USES

Line 1260: hz_party_site_uses hzpsu,

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,
1263: --okc_k_items cim_ib,
1264: okc_k_lines_b cle_ib,

Line 1862: hz_party_site_uses hzpsu,

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

Line 2380: hz_party_site_uses hzpsu,

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