APPS.OKL_COPY_CONTRACT_PVT dependencies on HZ_PARTY_SITE_USES

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

19545: x_object_id1_new OUT NOCOPY NUMBER
19546: ) IS
19547:
19548: --Cursors
19549: CURSOR c_get_iti_object_id1(p_party_site_id HZ_PARTY_SITE_USES.PARTY_SITE_ID%TYPE)
19550: IS
19551: SELECT psu.party_site_use_id
19552: FROM HZ_PARTY_SITE_USES psu,
19553: HZ_PARTY_SITES ps

Line 19552: FROM HZ_PARTY_SITE_USES psu,

19548: --Cursors
19549: CURSOR c_get_iti_object_id1(p_party_site_id HZ_PARTY_SITE_USES.PARTY_SITE_ID%TYPE)
19550: IS
19551: SELECT psu.party_site_use_id
19552: FROM HZ_PARTY_SITE_USES psu,
19553: HZ_PARTY_SITES ps
19554: WHERE ps.party_site_id = psu.party_site_id
19555: AND psu.site_use_type = 'INSTALL_AT'
19556: AND psu.party_site_id = p_party_site_id;

Line 19560: FROM hz_party_site_uses psu,

19556: AND psu.party_site_id = p_party_site_id;
19557:
19558: CURSOR l_site_use_csr (p_location_id IN NUMBER) IS
19559: SELECT psu.party_site_use_id
19560: FROM hz_party_site_uses psu,
19561: hz_party_sites ps
19562: WHERE psu.party_site_id = ps.party_site_id
19563: AND psu.site_use_type = 'INSTALL_AT'
19564: AND ps.location_id = p_location_id;