DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 7781: FROM okc_k_party_roles_b

7777:
7778: CURSOR temp_role_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
7779: --Fixed # Bug 5484903
7780: SELECT object1_id1
7781: FROM okc_k_party_roles_b
7782: WHERE dnz_chr_id = p_chr_id
7783: AND chr_id = dnz_chr_id
7784: AND jtot_object1_code = 'OKX_PARTY'
7785: AND rle_code = 'LESSEE';

Line 24727: FROM okc_k_party_roles_b

24723:
24724: CURSOR temp_cust_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
24725: --Fixed Bug # 5484903
24726: SELECT object1_id1
24727: FROM okc_k_party_roles_b
24728: WHERE dnz_chr_id = p_chr_id
24729: AND chr_id = dnz_chr_id
24730: AND jtot_object1_code = 'OKX_PARTY'
24731: AND rle_code = 'LESSEE' ;

Line 28277: FROM okc_k_party_roles_b

28273:
28274: CURSOR temp_role_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
28275: --Fixed Bug # 5484903
28276: SELECT object1_id1
28277: FROM okc_k_party_roles_b
28278: WHERE dnz_chr_id = p_chr_id
28279: AND chr_id = dnz_chr_id
28280: AND jtot_object1_code = 'OKX_PARTY'
28281: AND rle_code = 'LESSEE';