APPS.OKS_QA_DATA_INTEGRITY dependencies on HZ_CUST_ACCT_RELATE_ALL

Line 6576: -- replaced OKX_CUST_ACCT_RELATE_ALL_V with HZ_CUST_ACCT_RELATE_ALL

6572: AND chr_id = p_chr_id;
6573:
6574: -- If the party id does not belong to the customer or third party then
6575: -- it might belong to the related customer account. If not give an error.
6576: -- replaced OKX_CUST_ACCT_RELATE_ALL_V with HZ_CUST_ACCT_RELATE_ALL
6577: -- replaced OKX_CUSTOMER_ACCOUNTS_V with HZ_CUST_ACCOUNTS
6578: CURSOR get_related_cust_acct_id(orgId NUMBER, relatedCustAccId NUMBER,
6579: custPartyId NUMBER) IS
6580: SELECT A.CUST_ACCOUNT_ID, A.RELATED_CUST_ACCOUNT_ID

Line 6581: FROM HZ_CUST_ACCT_RELATE_ALL A,

6577: -- replaced OKX_CUSTOMER_ACCOUNTS_V with HZ_CUST_ACCOUNTS
6578: CURSOR get_related_cust_acct_id(orgId NUMBER, relatedCustAccId NUMBER,
6579: custPartyId NUMBER) IS
6580: SELECT A.CUST_ACCOUNT_ID, A.RELATED_CUST_ACCOUNT_ID
6581: FROM HZ_CUST_ACCT_RELATE_ALL A,
6582: HZ_CUST_ACCOUNTS CA
6583: WHERE CA.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID
6584: AND CA.PARTY_ID = custPartyId
6585: AND A.RELATED_CUST_ACCOUNT_ID = relatedCustAccId

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

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