APPS.OKL_AM_SHIPPING_INSTR_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 42: from OKC_K_PARTY_ROLES_B CPLB

38: -- Fix for bug 3562321 - Added dnz_chr_id in the where clause to avoid fts.
39: CURSOR okl_get_lessee_csr (p_khr_id IN NUMBER) IS
40: select CPLB.OBJECT1_ID1,
41: CPLB.JTOT_OBJECT1_CODE
42: from OKC_K_PARTY_ROLES_B CPLB
43: where CPLB.RLE_CODE = 'LESSEE'
44: and CPLB.DNZ_CHR_ID = CPLB.CHR_ID
45: and CPLB.DNZ_CHR_ID = p_khr_id;
46: