DBA Data[Home] [Help]

APPS.OKL_LESSEE_AS_VENDOR_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 251: l_cpl_id okc_k_party_roles_b.id%type;

247: i NUMBER;
248: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
249: lp_ppydv_rec ppydv_rec_type := p_ppydv_rec;
250: -- lx_ppydv_rec ppydv_rec_type := x_ppydv_rec;
251: l_cpl_id okc_k_party_roles_b.id%type;
252:
253: cursor c_cpl_id (p_chr_id number)
254: is
255: select kpr.id

Line 256: from okc_k_party_roles_b kpr

252:
253: cursor c_cpl_id (p_chr_id number)
254: is
255: select kpr.id
256: from okc_k_party_roles_b kpr
257: where kpr.rle_code = 'LESSEE'
258: and kpr.dnz_chr_id = p_chr_id
259: ;
260: