APPS.OKL_EVERGREEN_BILLING_PVT dependencies on IEX_WF_BAN_STATUS_PUB

Line 65: iex_wf_ban_status_pub.get_turninvoff(hca.party_id,hca.cust_account_id,SYSDATE) bkrpcy_sts

61: ------------------------------------------------------------
62: CURSOR distinct_evergreen_contracts( p_contract_number VARCHAR2 ) IS
63: SELECT distinct oklh.id khr_id,
64: okch.contract_number,
65: iex_wf_ban_status_pub.get_turninvoff(hca.party_id,hca.cust_account_id,SYSDATE) bkrpcy_sts
66: FROM okl_k_headers oklh,
67: okc_k_headers_b okch,
68: okc_statuses_b khs,
69: okl_streams stm,

Line 92: iex_wf_ban_status_pub.get_turninvoff(hca.party_id,hca.cust_account_id,SYSDATE);

88: OR stm.kle_id IS NULL
89: )
90: GROUP BY oklh.id,
91: okch.contract_number,
92: iex_wf_ban_status_pub.get_turninvoff(hca.party_id,hca.cust_account_id,SYSDATE);
93:
94: ------------------------------------------------------------
95: -- Extract all streams to be billed
96: ------------------------------------------------------------