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 2707: From hz_cust_accounts

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