DBA Data[Home] [Help]

APPS.OKL_LA_STREAM_PVT dependencies on HZ_LOCATIONS

Line 17582: FROM hz_locations hl,

17578: -- get the Lease install based location
17579: CURSOR ib_csr_lease (chrId NUMBER)
17580: IS
17581: SELECT DISTINCT hl.country country
17582: FROM hz_locations hl,
17583: hz_party_sites hps,
17584: hz_party_site_uses hpsu,
17585: okl_txl_itm_insts iti,
17586: okc_line_styles_b lse_ib,

Line 21916: FROM hz_locations hl,

21912: -- get the install based location
21913: CURSOR ib_csr (chrId NUMBER)
21914: IS
21915: SELECT DISTINCT hl.country country
21916: FROM hz_locations hl,
21917: hz_party_sites hps,
21918: hz_party_site_uses hpsu,
21919: okl_txl_itm_insts iti,
21920: okc_line_styles_b lse_ib,