DBA Data[Home] [Help]

APPS.OKL_VP_TERMINATE_PVT dependencies on OKX_INCIDENT_STATUSES_V

Line 45: FROM okx_incident_statuses_v xis,

41: WHERE sts.code = l_code;
42:
43: CURSOR cur_service_requests is
44: SELECT 'x'
45: FROM okx_incident_statuses_v xis,
46: okc_k_lines_b cle
47: WHERE cle.id = xis.contract_service_id
48: AND cle.dnz_chr_id = p_terminate_in_parameters_rec.p_contract_id
49: AND xis.status_code in ('OPEN'); -- Impact -- DepENDency on status of service requests