DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKX_INCIDENT_STATUSES_V

Line 1839: FROM OKX_INCIDENT_STATUSES_V xis,

1835:
1836: -- Cursor to get the service requests of contract
1837: CURSOR k_service_request_csr IS
1838: SELECT 'x'
1839: FROM OKX_INCIDENT_STATUSES_V xis,
1840: OKC_K_LINES_B cle
1841: WHERE cle.id = xis.contract_service_id
1842: AND cle.dnz_chr_id = p_contract_id
1843: AND xis.status_code IN ('OPEN');