APPS.IBE_MERGE_PVT dependencies on HZ_CUST_ACCOUNTS

Line 39: Where party_id in (Select party_id from hz_cust_accounts

35: l_allow_merge_flag := 'Y';
36:
37: Select party_type,party_id into l_party_type,l_party_id
38: From hz_parties
39: Where party_id in (Select party_id from hz_cust_accounts
40: Where cust_account_id = p_customer_id);
41:
42: Select party_id into l_dup_party_id
43: From hz_parties

Line 44: Where party_id in (Select party_id from hz_cust_accounts

40: Where cust_account_id = p_customer_id);
41:
42: Select party_id into l_dup_party_id
43: From hz_parties
44: Where party_id in (Select party_id from hz_cust_accounts
45: Where cust_account_id = p_duplicate_id);
46:
47: IBE_Util.Debug('IBE_MERGE_PVT.Allow_merge -party_type: '||l_party_type||' party_id: '||l_party_id||' and duplicate party id: '||l_dup_party_id);
48:

Line 72: from hz_cust_accounts

68: p_account_id NUMBER) RETURN NUMBER IS
69: l_party_id NUMBER :=0 ;
70: BEGIN
71: select PARTY_ID INTO l_party_id
72: from hz_cust_accounts
73: where cust_account_id=p_account_id;
74: IF l_party_id IS NULL THEN
75: RETURN l_party_id;
76: END IF;

Line 1421: from hz_cust_accounts

1417:
1418:
1419: cursor find_account(p_party_id number) is
1420: select cust_account_id
1421: from hz_cust_accounts
1422: where party_id=p_party_id and rownum=1
1423: for update nowait;
1424:
1425: l_merge_reason_code VARCHAR2(30);