DBA Data[Home] [Help]

APPS.PVX_MISC_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 2137: from hz_cust_account_roles hzcar

2133: and hzr.start_date <= sysdate
2134: and nvl(hzr.end_date,sysdate) >= sysdate
2135: and not exists
2136: ( select 1
2137: from hz_cust_account_roles hzcar
2138: where hzcar.cust_account_id IN (select cust_account_id from hz_cust_accounts where party_id = hzr.object_id)
2139: and nvl(hzcar.status,'A')='A'
2140: and nvl(hzcar.begin_date,sysdate) <= sysdate
2141: and nvl(hzcar.end_date,sysdate) >= sysdate