DBA Data[Home] [Help]

APPS.OKL_CONTRACT_LINE_ITEM_PVT dependencies on OKX_COVERED_ASSET_V

Line 105: FROM OKX_COVERED_ASSET_V cas

101: SELECT cas.id1,
102: cas.id2,
103: cas.name,
104: cas.description
105: FROM OKX_COVERED_ASSET_V cas
106: WHERE cas.okc_line_status NOT IN ('EXPIRED','TERMINATED','CANCELLED','ABANDONED')
107: AND cas.dnz_chr_id = p_dnz_chr_id -- included for bug#5484903
108: AND cas.name = NVL(p_name,cas.name)
109: AND cas.id1 = NVL(p_id1,cas.id1)