DBA Data[Home] [Help]

APPS.OKL_AM_TERMINATE_INV_AGMT_PVT dependencies on OKL_K_HEADERS

Line 1112: OKL_K_HEADERS KHR,

1108: KHR.pdt_id,
1109: POL.id pool_id,
1110: POL.pool_number
1111: FROM OKC_K_HEADERS_B CHR,
1112: OKL_K_HEADERS KHR,
1113: OKL_POOLS POL
1114: WHERE CHR.id = p_ia_id
1115: AND CHR.id = KHR.id
1116: AND CHR.id = POL.khr_id;

Line 1574: FROM Okl_k_headers

1570:
1571: -- get legal_entity_id
1572: CURSOR get_le_csr (p_ia_id IN NUMBER)is
1573: SELECT legal_entity_id
1574: FROM Okl_k_headers
1575: WHERE khr_id = p_ia_id;
1576:
1577: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1578: lp_tcnv_rec tcnv_rec_type ;