DBA Data[Home] [Help]

APPS.PVX_UTILITY_PVT dependencies on HZ_CUST_ACCOUNTS

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';

Line 704: from hz_cust_accounts where cust_account_id in

700: and b.cust_account_id=a.value_number and nvl(status,'A')='A';
701:
702: CURSOR get_account(cv_contact_rel_party_id NUMBER) IS
703: select cust_account_id
704: from hz_cust_accounts where cust_account_id in
705: (select cust_account_id
706: from hz_cust_account_roles
707: where party_id = cv_contact_rel_party_id
708: and nvl(status,'A')='A'