APPS.OE_CREATE_ACCOUNT_INFO dependencies on HZ_CUST_ACCT_RELATE

Line 81: FROM hz_cust_acct_relate

77: AND status='A';
78:
79: CURSOR c_related_cust_account_id (in_cust_account_id in number) IS
80: SELECT cust_account_id
81: FROM hz_cust_acct_relate
82: WHERE related_cust_account_id=in_cust_account_id
83: AND status='A';
84:
85: l_contact_status varchar2(10) := 'XXX';

Line 682: from hz_cust_acct_relate

678: oe_debug_pub.add('AAC:RC: Customers are different. Create relationship');
679: begin
680: select cust_account_id
681: into matched_cust
682: from hz_cust_acct_relate
683: where related_cust_account_id=l_cust_account_id
684: and cust_account_id=p_site_tbl(i).p_cust_account_id
685: AND status ='A' --added for bug 11699930
686: and rownum = 1; --added for bug# 14113693