APPS.IBY_FNDCPT_COMMON_PUB dependencies on HZ_PARTY_PREFERENCES

Line 26: hz_cust_accounts b, hz_party_preferences c

22: AND ( (party_id = ci_party_id)
23: OR ci_party_id IN
24: ( SELECT DISTINCT a.party_id
25: FROM hz_cust_account_roles a,
26: hz_cust_accounts b, hz_party_preferences c
27: WHERE (b.cust_account_id = ci_cust_acct_id)
28: AND (NVL(a.status,'A')= 'A')
29: AND (NVL(b.status, 'A') = 'A')
30: AND (a.cust_account_id = b.cust_account_id)