APPS.HZ_CUSTOMER_PROFILE_V2PUB dependencies on HZ_CUST_ACCOUNTS

Line 116: FROM hz_cust_accounts a,

112: RETURN NUMBER
113: IS
114: CURSOR c1 IS
115: SELECT a.party_id
116: FROM hz_cust_accounts a,
117: hz_parties b
118: WHERE a.cust_account_id = p_cust_account_id
119: AND a.party_id = b.party_id
120: AND b.status = DECODE(p_active,'ALL',b.status,p_active);

Line 398: -- cust_account_id and party_id must be associated in hz_cust_accounts.

394: -- cust_account_id must be associated with an active party_id
395: -- party_id = this active party_id
396: -- If party_id is not null and cust_account_id is not null then
397: -- party_id must be active
398: -- cust_account_id and party_id must be associated in hz_cust_accounts.
399: --
400: IF ( p_customer_profile_rec.party_id IS NULL OR
401: p_customer_profile_rec.party_id = FND_API.G_MISS_NUM )
402: THEN