APPS.OKL_SPLIT_ASSET_PVT dependencies on HZ_PARTY_SITE_USES

Line 4731: FROM hz_party_site_uses

4727:
4728: --Cursor to get install site use id
4729: CURSOR inst_site_csr (pty_site_id IN NUMBER) IS
4730: SELECT TO_CHAR(Party_site_use_id) party_site_use_id
4731: FROM hz_party_site_uses
4732: WHERE party_site_id = pty_site_id
4733: AND site_use_type = 'INSTALL_AT';
4734:
4735:

Line 4739: FROM hz_party_site_uses psu,

4735:
4736: --BUG# 3569441
4737: CURSOR inst_loc_csr (loc_id IN NUMBER) IS
4738: SELECT TO_CHAR(psu.party_site_use_id) party_site_use_id
4739: FROM hz_party_site_uses psu,
4740: hz_party_sites ps
4741: WHERE psu.party_site_id = ps.party_site_id
4742: AND psu.site_use_type = 'INSTALL_AT'
4743: AND ps.location_id = loc_id;

Line 5334: FROM hz_party_site_uses

5330:
5331: --Cursor to get install site use id
5332: CURSOR inst_site_csr (pty_site_id IN NUMBER) IS
5333: SELECT TO_CHAR(Party_site_use_id) party_site_use_id
5334: FROM hz_party_site_uses
5335: WHERE party_site_id = pty_site_id
5336: AND site_use_type = 'INSTALL_AT';
5337:
5338: --BUG# 3569441

Line 5341: FROM hz_party_site_uses psu,

5337:
5338: --BUG# 3569441
5339: CURSOR inst_loc_csr (loc_id IN NUMBER) IS
5340: SELECT TO_CHAR(psu.party_site_use_id) party_site_use_id
5341: FROM hz_party_site_uses psu,
5342: hz_party_sites ps
5343: WHERE psu.party_site_id = ps.party_site_id
5344: AND psu.site_use_type = 'INSTALL_AT'
5345: AND ps.location_id = loc_id;