APPS.OKS_QA_DATA_INTEGRITY dependencies on HZ_CUST_ACCT_RELATE_ALL

Line 6429: -- replaced OKX_CUST_ACCT_RELATE_ALL_V with HZ_CUST_ACCT_RELATE_ALL

6425: AND chr_id = p_chr_id;
6426:
6427: -- If the party id does not belong to the customer or third party then
6428: -- it might belong to the related customer account. If not give an error.
6429: -- replaced OKX_CUST_ACCT_RELATE_ALL_V with HZ_CUST_ACCT_RELATE_ALL
6430: -- replaced OKX_CUSTOMER_ACCOUNTS_V with HZ_CUST_ACCOUNTS
6431: CURSOR get_related_cust_acct_id(orgId NUMBER, relatedCustAccId NUMBER,
6432: custPartyId NUMBER) IS
6433: SELECT A.CUST_ACCOUNT_ID, A.RELATED_CUST_ACCOUNT_ID

Line 6434: FROM HZ_CUST_ACCT_RELATE_ALL A,

6430: -- replaced OKX_CUSTOMER_ACCOUNTS_V with HZ_CUST_ACCOUNTS
6431: CURSOR get_related_cust_acct_id(orgId NUMBER, relatedCustAccId NUMBER,
6432: custPartyId NUMBER) IS
6433: SELECT A.CUST_ACCOUNT_ID, A.RELATED_CUST_ACCOUNT_ID
6434: FROM HZ_CUST_ACCT_RELATE_ALL A,
6435: HZ_CUST_ACCOUNTS CA
6436: WHERE CA.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID
6437: AND CA.PARTY_ID = custPartyId
6438: AND A.RELATED_CUST_ACCOUNT_ID = relatedCustAccId

Line 6650: (SELECT CA.PARTY_ID, A.Status, CA.STATUS PARTY_STATUS FROM HZ_CUST_ACCT_RELATE_ALL A,

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
6654: WHERE A.rle_code NOT IN ('VENDOR', 'MERCHANT')