APPS.OKS_QA_DATA_INTEGRITY dependencies on OKC_K_PARTY_ROLES_V

Line 6409: FROM okc_k_party_roles_v

6405: -- stored on the contract header.
6406: -- If no value is returned then check the related customers
6407: CURSOR cust_exist_csr(cust_id NUMBER) IS
6408: SELECT object1_id1 party_id
6409: FROM okc_k_party_roles_v
6410: WHERE rle_code NOT IN ('VENDOR', 'MERCHANT')
6411: AND object1_id1 = cust_id
6412: AND dnz_chr_id = p_chr_id
6413: AND chr_id = p_chr_id;

Line 6422: FROM okc_k_party_roles_v

6418: WHERE id = p_chr_id;
6419:
6420: CURSOR get_contr_cust IS
6421: SELECT object1_id1 party_id
6422: FROM okc_k_party_roles_v
6423: WHERE rle_code NOT IN ('VENDOR', 'MERCHANT')
6424: AND dnz_chr_id = p_chr_id
6425: AND chr_id = p_chr_id;
6426:

Line 6576: FROM okc_k_party_roles_v

6572: AND status = 'A';
6573:
6574: CURSOR get_contr_cust IS
6575: SELECT object1_id1 party_id, rle_code
6576: FROM okc_k_party_roles_v
6577: WHERE rle_code NOT IN ('VENDOR', 'MERCHANT')
6578: AND dnz_chr_id = p_chr_id
6579: AND chr_id = p_chr_id;
6580:

Line 6649: SELECT rle_code, B.Status, B.PARTY_STATUS FROM okc_k_party_roles_v A,

6645:
6646: -- Use this Cursor to find Customer /Third Party related to the
6647: -- Customer_account which is inactive
6648: CURSOR get_parent_party (p_org_id IN NUMBER, p_id IN NUMBER) IS
6649: SELECT rle_code, B.Status, B.PARTY_STATUS FROM okc_k_party_roles_v A,
6650: (SELECT CA.PARTY_ID, A.Status, CA.STATUS PARTY_STATUS FROM HZ_CUST_ACCT_RELATE_ALL A,
6651: HZ_CUST_ACCOUNTS CA WHERE CA.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID
6652: AND A.RELATED_CUST_ACCOUNT_ID = p_id
6653: AND A.org_id = p_org_id) B