APPS.OKL_MLA_CREATE_UPDATE_PUB dependencies on OKC_K_PARTY_ROLES_V

Line 382: l_vp_cpl_id okc_k_party_roles_v.id%TYPE := NULL;

378:
379: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
380: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
381:
382: l_vp_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
383: x_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
384: l_chr_id okc_k_headers_b.id%type := NULL;
385:
386: CURSOR c_vp_cpl_csr(p_source_id NUMBER) IS

Line 383: x_cpl_id okc_k_party_roles_v.id%TYPE := NULL;

379: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
380: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
381:
382: l_vp_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
383: x_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
384: l_chr_id okc_k_headers_b.id%type := NULL;
385:
386: CURSOR c_vp_cpl_csr(p_source_id NUMBER) IS
387: SELECT id, object_version_number, sfwt_flag,

Line 401: FROM okc_k_party_roles_v cplv

397: attribute12, attribute13, attribute14,
398: attribute15, created_by, creation_date,
399: last_updated_by, last_update_date, last_update_login,
400: cust_acct_id, bill_to_site_use_id
401: FROM okc_k_party_roles_v cplv
402: WHERE cplv.rle_code = G_LEASE_VENDOR
403: AND cplv.chr_id = p_source_id; -- vendor program id
404:
405: