APPS.OKS_QA_DATA_INTEGRITY dependencies on OKC_K_PARTY_ROLES_B

Line 1630: , Okc_k_party_roles_b Party

1626:
1627: CURSOR l_Contact_csr(p_cle_id NUMBER) IS
1628: SELECT Contact.object1_id1
1629: FROM Okc_contacts Contact
1630: , Okc_k_party_roles_b Party
1631: , okc_k_lines_b lines
1632: WHERE Contact.cpl_id = Party.id
1633: AND party.cle_id = p_cle_id
1634: AND party.jtot_object1_code = 'OKX_PARTY'

Line 1678: ,okc_k_party_roles_b party

1674:
1675: CURSOR l_salesperson_contact IS
1676: SELECT contact.object1_id1
1677: FROM okc_contacts contact
1678: ,okc_k_party_roles_b party
1679: ,okc_k_headers_all_b header
1680: WHERE contact.cpl_id = party.id
1681: AND party.chr_id = p_chr_id
1682: AND party.jtot_object1_code = 'OKX_OPERUNIT' --'okx_party'

Line 2072: FROM OKC_K_PARTY_ROLES_B cpl

2068: l_cle1_rec l_cle1_csr%ROWTYPE;
2069:
2070: CURSOR l_cpl_csr (p_rle_code VARCHAR2) IS
2071: SELECT COUNT( * )
2072: FROM OKC_K_PARTY_ROLES_B cpl
2073: WHERE cpl.rle_code = p_rle_code
2074: AND cpl.dnz_chr_id = p_chr_id
2075: AND cpl.cle_id IS NULL;
2076:

Line 6639: FROM okc_k_party_roles_b

6635:
6636:
6637: CURSOR Get_Relationship(p_chr_id IN NUMBER, p_party_id IN NUMBER) IS
6638: SELECT rle_code
6639: FROM okc_k_party_roles_b
6640: WHERE rle_code NOT IN ('VENDOR', 'MERCHANT')
6641: AND dnz_chr_id = p_chr_id
6642: AND chr_id = p_chr_id
6643: AND object1_id1 = p_party_id;