DBA Data[Home] [Help]

APPS.PVX_UTILITY_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 706: from hz_cust_account_roles

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'
709: )
710: and nvl(status,'A')='A'