APPS.OKC_OKS_PUB dependencies on OKC_K_PARTY_ROLES_B

Line 33: okc_k_party_roles_b pty

29: CURSOR l_get_contracts_csr
30: IS
31: SELECT hdr.id, contract_number
32: FROM okc_k_headers_b hdr,
33: okc_k_party_roles_b pty
34: WHERE hdr.id=pty.chr_id
35: AND pty.rle_code='CUSTOMER'
36: AND pty.object1_id1= to_char(p_to_id)
37: AND hdr.id IN (SELECT DISTINCT (dnz_chr_id)