APPS.OKL_COPY_ASSET_PVT dependencies on HZ_PARTY_SITE_USES

Line 4225: CURSOR c_get_iti_object_id1(p_party_site_id HZ_PARTY_SITE_USES.PARTY_SITE_ID%TYPE)

4221: AND cle.dnz_chr_id = cim.dnz_chr_id
4222: AND cle.lse_id = lse.id
4223: AND lse.lty_code = G_MODEL_LINE_LTY_CODE;
4224:
4225: CURSOR c_get_iti_object_id1(p_party_site_id HZ_PARTY_SITE_USES.PARTY_SITE_ID%TYPE)
4226: IS
4227: SELECT psu.party_site_use_id
4228: FROM HZ_PARTY_SITE_USES psu,
4229: HZ_PARTY_SITES ps

Line 4228: FROM HZ_PARTY_SITE_USES psu,

4224:
4225: CURSOR c_get_iti_object_id1(p_party_site_id HZ_PARTY_SITE_USES.PARTY_SITE_ID%TYPE)
4226: IS
4227: SELECT psu.party_site_use_id
4228: FROM HZ_PARTY_SITE_USES psu,
4229: HZ_PARTY_SITES ps
4230: WHERE ps.party_site_id = psu.party_site_id
4231: AND psu.site_use_type = 'INSTALL_AT'
4232: AND psu.party_site_id = p_party_site_id;

Line 4245: FROM hz_party_site_uses psu,

4241: l_loc_type_rec l_loc_type_csr%ROWTYPE;
4242:
4243: CURSOR l_site_use_csr (p_location_id in number) is
4244: SELECT psu.party_site_use_id
4245: FROM hz_party_site_uses psu,
4246: hz_party_sites ps
4247: WHERE psu.party_site_id = ps.party_site_id
4248: AND psu.site_use_type = 'INSTALL_AT'
4249: AND ps.location_id = p_location_id;