APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 1460: from okc_k_party_roles_B

1456: CURSOR check_party_csr(p_chr_id NUMBER, p_rle_code VARCHAR2,p_id1 VARCHAR2, p_id2 VARCHAR2) IS
1457:
1458: --Start modified abhsaxen for performance SQLID 20562697
1459: select count(1)
1460: from okc_k_party_roles_B
1461: where dnz_chr_id = p_chr_id
1462: and chr_id = p_chr_id
1463: and rle_code = p_rle_code
1464: and object1_id1 = p_id1

Line 7256: l_orig_lse_object1_id1 okc_k_party_roles_b.object1_id1%type := null;

7252: where CURRENCY_CODE = p_currency_code;
7253:
7254:
7255: row_cnt number;
7256: l_orig_lse_object1_id1 okc_k_party_roles_b.object1_id1%type := null;
7257: l_re_book okc_k_headers_b.orig_system_source_code%type := null;
7258: l_orig_cust_acct_id okc_k_headers_b.cust_acct_id%type := null;
7259:
7260: cursor l_re_book_csr is

Line 7267: from okc_k_party_roles_b

7263: where chr.id = p_chr_id;
7264:
7265: cursor l_get_cust_csr is
7266: select object1_id1
7267: from okc_k_party_roles_b
7268: where rle_code = 'LESSEE'
7269: and dnz_chr_id = p_chr_id
7270: and chr_id = p_chr_id;
7271: