APPS.IBY_FNDCPT_COMMON_PUB dependencies on HZ_CUST_ACCOUNT_ROLES

Line 25: FROM hz_cust_account_roles a,

21: WHERE (cust_account_id = ci_cust_acct_id)
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')