APPS.IBE_MERGE_PVT dependencies on HZ_CUST_ACCOUNTS

Line 43: Where party_id in (Select party_id from hz_cust_accounts

39: Begin
40:
41: Select party_type,party_id into l_party_type,l_party_id
42: From hz_parties
43: Where party_id in (Select party_id from hz_cust_accounts
44: Where cust_account_id = p_customer_id);
45:
46: Select party_id into l_dup_party_id
47: From hz_parties

Line 48: Where party_id in (Select party_id from hz_cust_accounts

44: Where cust_account_id = p_customer_id);
45:
46: Select party_id into l_dup_party_id
47: From hz_parties
48: Where party_id in (Select party_id from hz_cust_accounts
49: Where cust_account_id = p_duplicate_id);
50:
51:
52: If ((l_Party_type = 'ORGANIZATION') AND (l_party_id <> l_dup_party_id)) Then

Line 87: from hz_cust_accounts

83: p_account_id NUMBER) RETURN NUMBER IS
84: l_party_id NUMBER :=0 ;
85: BEGIN
86: select PARTY_ID INTO l_party_id
87: from hz_cust_accounts
88: where cust_account_id=p_account_id;
89: IF l_party_id IS NULL THEN
90: RETURN l_party_id;
91: END IF;

Line 1456: from hz_cust_accounts

1452:
1453:
1454: cursor find_account(p_party_id number) is
1455: select cust_account_id
1456: from hz_cust_accounts
1457: where party_id=p_party_id and rownum=1
1458: for update nowait;
1459:
1460: l_merge_reason_code VARCHAR2(30);