APPS.OKL_ACTIVATE_IB_PVT dependencies on HZ_PARTY_SITE_USES

Line 1496: FROM HZ_PARTY_SITE_USES HPSU, HZ_PARTY_SITES HPS

1492: --cursor to fetch party location id
1493: CURSOR instance_loc_csr (p_site_use_id1 IN VARCHAR2) is
1494: SELECT HPS.location_id,
1495: HPS.party_site_id
1496: FROM HZ_PARTY_SITE_USES HPSU, HZ_PARTY_SITES HPS
1497: WHERE HPS.party_site_id = HPSU.party_site_id
1498: AND HPSU.party_site_use_id = p_site_use_id1;
1499:
1500: --rkuttiya added for IB Link User story 22-jan-2008 sprint 7

Line 2515: hz_party_site_uses hpsu

2511: Cursor l_party_site_csr (p_site_use_id in number) is
2512: Select hps.location_id,
2513: hpsu.party_site_id
2514: from hz_party_sites hps,
2515: hz_party_site_uses hpsu
2516: where hps.party_site_id = hpsu.party_site_id
2517: and hpsu.party_site_use_id = p_site_use_id;
2518:
2519: l_party_site_rec l_party_site_csr%ROWTYPE;