DBA Data[Home] [Help]

APPS.OKL_ARINTF_PVT dependencies on IEX_WF_BAN_STATUS_PUB

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

2034: ,khr.contract_number contract_number
2035: ,tai.id tai_id
2036: ,tai.okl_source_billing_trx
2037: ,tai.ixx_id customer_id
2038: ,iex_wf_ban_status_pub.get_turninvoff(hca.party_id,hca.cust_account_id,SYSDATE) bankruptcy_sts
2039: FROM okl_trx_ar_invoices_b tai,
2040: okc_k_headers_b khr,
2041: hz_cust_accounts hca
2042: WHERE tai.khr_id = khr.id

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

2080: CURSOR vndr_bankruptcy_csr IS
2081: SELECT distinct khr.id khr_id
2082: ,khr.contract_number contract_number
2083: ,tai.ixx_id vendor_customer_id
2084: ,iex_wf_ban_status_pub.get_turninvoff(hca.party_id,hca.cust_account_id,SYSDATE) bankruptcy_sts
2085: FROM okl_trx_ar_invoices_b tai,
2086: okc_k_headers_b khr,
2087: hz_cust_accounts hca,
2088: okc_k_party_roles_b opr