DBA Data[Home] [Help]

APPS.OKC_PRICE_PUB dependencies on OKC_GOVERNANCES_V

Line 719: From OKC_GOVERNANCES_V

715: Where id = p_hdr_id;
716:
717: Cursor Get_agreement_Csr(p_id Number) Is
718: Select Isa_Agreement_id
719: From OKC_GOVERNANCES_V
720: Where dnz_chr_id = p_id
721: AND cle_id IS NULL;
722: -- Changed Because it gives full table scan as it dont have a Index on Chr_Id.--Jomy
723: -- Where chr_id = p_id;