APPS.OKL_SEC_AGREEMENT_PVT dependencies on OKC_QA_CHECK_LISTS_TL

Line 1562: l_qcl_id OKC_QA_CHECK_LISTS_TL.ID%TYPE;

1558: l_api_name CONSTANT VARCHAR2(30) := 'create_sec_agreement_pvt';
1559: l_api_version CONSTANT NUMBER := 1.0;
1560: i NUMBER;
1561: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1562: l_qcl_id OKC_QA_CHECK_LISTS_TL.ID%TYPE;
1563: l_row_not_found BOOLEAN := FALSE;
1564:
1565: lp_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1566: lx_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;

Line 1579: FROM OKC_QA_CHECK_LISTS_TL qcl,

1575:
1576:
1577: CURSOR c_qcl IS
1578: SELECT qcl.id
1579: FROM OKC_QA_CHECK_LISTS_TL qcl,
1580: OKC_QA_CHECK_LISTS_B qclv
1581: WHERE qclv.Id = qcl.id
1582: AND UPPER(qcl.name) = 'OKL LA QA INVESTOR AGMNT'
1583: AND qcl.LANGUAGE = 'US'