DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 7949: FROM okc_k_party_roles_b

7945:
7946: CURSOR temp_role_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
7947: --Fixed # Bug 5484903
7948: SELECT object1_id1
7949: FROM okc_k_party_roles_b
7950: WHERE dnz_chr_id = p_chr_id
7951: AND chr_id = dnz_chr_id
7952: AND jtot_object1_code = 'OKX_PARTY'
7953: AND rle_code = 'LESSEE';

Line 24969: FROM okc_k_party_roles_b

24965:
24966: CURSOR temp_cust_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
24967: --Fixed Bug # 5484903
24968: SELECT object1_id1
24969: FROM okc_k_party_roles_b
24970: WHERE dnz_chr_id = p_chr_id
24971: AND chr_id = dnz_chr_id
24972: AND jtot_object1_code = 'OKX_PARTY'
24973: AND rle_code = 'LESSEE' ;

Line 28574: FROM okc_k_party_roles_b

28570:
28571: CURSOR temp_role_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
28572: --Fixed Bug # 5484903
28573: SELECT object1_id1
28574: FROM okc_k_party_roles_b
28575: WHERE dnz_chr_id = p_chr_id
28576: AND chr_id = dnz_chr_id
28577: AND jtot_object1_code = 'OKX_PARTY'
28578: AND rle_code = 'LESSEE';