DBA Data[Home] [Help]

APPS.OE_INLINE_CUSTOMER_PUB dependencies on HZ_CUST_ACCOUNTS

Line 1447: From hz_cust_accounts

1443: oe_debug_pub.add( 'ENTERNING VALIDATE_CUSTOMER_NUMBER API' ) ;
1444: END IF;
1445: Select party_id, cust_account_id
1446: Into x_party_id, x_account_id
1447: From hz_cust_accounts
1448: Where account_number = p_customer_number;
1449: x_return_status := FND_API.G_RET_STS_SUCCESS;
1450:
1451: IF l_debug_level > 0 THEN

Line 1816: From hz_cust_accounts

1812: l_customer_info_id := address_info_rec.Current_Customer_id;
1813: Begin
1814: Select party_id
1815: Into l_customer_party_id
1816: From hz_cust_accounts
1817: Where cust_account_id = l_customer_info_id;
1818: Exception
1819: When No_Data_Found Then
1820: IF l_debug_level > 0 THEN

Line 2706: From hz_cust_accounts

2702: l_customer_info_id := contact_rec.Current_Customer_id;
2703: Begin
2704: Select party_id
2705: Into l_customer_party_id
2706: From hz_cust_accounts
2707: Where cust_account_id = l_customer_info_id;
2708: Exception
2709: When No_Data_Found Then
2710: IF l_debug_level > 0 THEN