DBA Data[Home] [Help]

APPS.OKS_QA_DATA_INTEGRITY dependencies on OKX_CUSTOMER_ACCOUNTS_V

Line 3016: FROM okx_customer_accounts_v

3012: **/
3013:
3014: CURSOR Get_Customer_Name (p_cust_acct_id IN NUMBER) IS
3015: SELECT name
3016: FROM okx_customer_accounts_v
3017: WHERE id1 = p_cust_acct_id;
3018:
3019: -- IKON ENHANCEMENT -
3020: CURSOR get_hdr_tax_exemp(p_chr_id NUMBER) IS

Line 6577: -- replaced OKX_CUSTOMER_ACCOUNTS_V with HZ_CUST_ACCOUNTS

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
6581: FROM HZ_CUST_ACCT_RELATE_ALL A,