DBA Data[Home] [Help]

APPS.OKL_UBB_PVT dependencies on IEX_WF_BAN_STATUS_PUB

Line 177: iex_wf_ban_status_pub.get_turninvoff(hca.party_id,hca.cust_account_id,SYSDATE) bankruptcy_sts

173: -- Below Cursor distinct_khr_cur is added by Venkatho as part of Bug# 14119181
174: CURSOR distinct_khr_cur IS
175: select distinct rel.chr_id okl_khr_id,
176: chr.contract_number contract_number,
177: iex_wf_ban_status_pub.get_turninvoff(hca.party_id,hca.cust_account_id,SYSDATE) bankruptcy_sts
178: from okc_k_rel_objs rel, okc_k_lines_v lns, oks_bill_cont_lines_v oks_cont,
179: OKS_BILL_SUB_LINES_V OKS_LNS, OKC_K_HEADERS_B chr,
180: OKC_K_ITEMS ITEMS, OKL_CNTR_LVLNG_LNS_V CNTR, okc_k_lines_v cov_asset,
181: hz_cust_accounts hca