APPS.OKL_COPY_CONTRACT_PVT dependencies on HZ_PARTY_SITE_USES

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

19368: x_object_id1_new OUT NOCOPY NUMBER
19369: ) IS
19370:
19371: --Cursors
19372: CURSOR c_get_iti_object_id1(p_party_site_id HZ_PARTY_SITE_USES.PARTY_SITE_ID%TYPE)
19373: IS
19374: SELECT psu.party_site_use_id
19375: FROM HZ_PARTY_SITE_USES psu,
19376: HZ_PARTY_SITES ps

Line 19375: FROM HZ_PARTY_SITE_USES psu,

19371: --Cursors
19372: CURSOR c_get_iti_object_id1(p_party_site_id HZ_PARTY_SITE_USES.PARTY_SITE_ID%TYPE)
19373: IS
19374: SELECT psu.party_site_use_id
19375: FROM HZ_PARTY_SITE_USES psu,
19376: HZ_PARTY_SITES ps
19377: WHERE ps.party_site_id = psu.party_site_id
19378: AND psu.site_use_type = 'INSTALL_AT'
19379: AND psu.party_site_id = p_party_site_id;

Line 19383: FROM hz_party_site_uses psu,

19379: AND psu.party_site_id = p_party_site_id;
19380:
19381: CURSOR l_site_use_csr (p_location_id IN NUMBER) IS
19382: SELECT psu.party_site_use_id
19383: FROM hz_party_site_uses psu,
19384: hz_party_sites ps
19385: WHERE psu.party_site_id = ps.party_site_id
19386: AND psu.site_use_type = 'INSTALL_AT'
19387: AND ps.location_id = p_location_id;