APPS.OKS_QA_DATA_INTEGRITY dependencies on OKC_K_PARTY_ROLES_B

Line 1699: , Okc_k_party_roles_b Party

1695:
1696: CURSOR l_Contact_csr(p_cle_id NUMBER) IS
1697: SELECT Contact.object1_id1
1698: FROM Okc_contacts Contact
1699: , Okc_k_party_roles_b Party
1700: , okc_k_lines_b lines
1701: WHERE Contact.cpl_id = Party.id
1702: AND party.cle_id = p_cle_id
1703: AND party.jtot_object1_code = 'OKX_PARTY'

Line 1747: ,okc_k_party_roles_b party

1743:
1744: CURSOR l_salesperson_contact IS
1745: SELECT contact.object1_id1
1746: FROM okc_contacts contact
1747: ,okc_k_party_roles_b party
1748: ,okc_k_headers_all_b header
1749: WHERE contact.cpl_id = party.id
1750: AND party.chr_id = p_chr_id
1751: AND party.jtot_object1_code = 'OKX_OPERUNIT' --'okx_party'

Line 2141: FROM OKC_K_PARTY_ROLES_B cpl

2137: l_cle1_rec l_cle1_csr%ROWTYPE;
2138:
2139: CURSOR l_cpl_csr (p_rle_code VARCHAR2) IS
2140: SELECT COUNT( * )
2141: FROM OKC_K_PARTY_ROLES_B cpl
2142: WHERE cpl.rle_code = p_rle_code
2143: AND cpl.dnz_chr_id = p_chr_id
2144: AND cpl.cle_id IS NULL;
2145:

Line 6786: FROM okc_k_party_roles_b

6782:
6783:
6784: CURSOR Get_Relationship(p_chr_id IN NUMBER, p_party_id IN NUMBER) IS
6785: SELECT rle_code
6786: FROM okc_k_party_roles_b
6787: WHERE rle_code NOT IN ('VENDOR', 'MERCHANT')
6788: AND dnz_chr_id = p_chr_id
6789: AND chr_id = p_chr_id
6790: AND object1_id1 = p_party_id;

Line 6797: FROM okc_k_party_roles_b A,

6793: -- Use this Cursor to find Customer /Third Party related to the
6794: -- Customer_account which is inactive
6795: CURSOR get_parent_party (p_org_id IN NUMBER, p_id IN NUMBER) IS
6796: SELECT /*+ index(B.CA HZ_CUST_ACCOUNTS_N2) */ rle_code, B.Status, B.PARTY_STATUS
6797: FROM okc_k_party_roles_b A,
6798: (SELECT CA.PARTY_ID, A.Status, CA.STATUS PARTY_STATUS FROM HZ_CUST_ACCT_RELATE_ALL A,
6799: HZ_CUST_ACCOUNTS CA WHERE CA.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID
6800: AND A.RELATED_CUST_ACCOUNT_ID = p_id
6801: AND A.org_id = p_org_id) B