APPS.PVX_UTILITY_PVT dependencies on HZ_PARTY_PREFERENCES

Line 696: from hz_party_preferences a, hz_cust_accounts b

692: l_account_id NUMBER;
693:
694: CURSOR get_primary_account(cv_contact_rel_party_id NUMBER) IS
695: select b.cust_account_id
696: from hz_party_preferences a, hz_cust_accounts b
697: where category = 'PRIMARY_ACCOUNT'
698: and a.preference_code = 'CUSTOMER_ACCOUNT_ID'
699: and a.party_id = cv_contact_rel_party_id
700: and b.cust_account_id=a.value_number and nvl(status,'A')='A';