APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 1476: from okc_k_party_roles_B

1472: CURSOR check_party_csr(p_chr_id NUMBER, p_rle_code VARCHAR2,p_id1 VARCHAR2, p_id2 VARCHAR2) IS
1473:
1474: --Start modified abhsaxen for performance SQLID 20562697
1475: select count(1)
1476: from okc_k_party_roles_B
1477: where dnz_chr_id = p_chr_id
1478: and chr_id = p_chr_id
1479: and rle_code = p_rle_code
1480: and object1_id1 = p_id1

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

7268: where CURRENCY_CODE = p_currency_code;
7269:
7270:
7271: row_cnt number;
7272: l_orig_lse_object1_id1 okc_k_party_roles_b.object1_id1%type := null;
7273: l_re_book okc_k_headers_b.orig_system_source_code%type := null;
7274: l_orig_cust_acct_id okc_k_headers_b.cust_acct_id%type := null;
7275:
7276: cursor l_re_book_csr is

Line 7283: from okc_k_party_roles_b

7279: where chr.id = p_chr_id;
7280:
7281: cursor l_get_cust_csr is
7282: select object1_id1
7283: from okc_k_party_roles_b
7284: where rle_code = 'LESSEE'
7285: and dnz_chr_id = p_chr_id
7286: and chr_id = p_chr_id;
7287: