APPS.IBU_HOME_PAGE_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 318: from HZ_CUST_ACCOUNT_ROLES

314: from HZ_CUST_ACCOUNTS
315: where status = 'A'
316: and cust_account_id in
317: (select cust_account_id
318: from HZ_CUST_ACCOUNT_ROLES
319: where party_id = p_customer_id
320: and current_role_state = 'A')
321: order by account_number;
322:

Line 325: from hz_cust_accounts r, hz_cust_account_roles s

321: order by account_number;
322:
323: /*
324: select r.cust_account_id, r.account_number
325: from hz_cust_accounts r, hz_cust_account_roles s
326: where r.cust_account_id = s.cust_account_id
327: and s.current_role_state = 'A'
328: and s.party_id = p_customer_id
329: order by r.account_number;

Line 339: from HZ_CUST_ACCOUNT_ROLES

335: where status = 'A'
336: and party_id = p_company_id
337: and cust_account_id in
338: (select cust_account_id
339: from HZ_CUST_ACCOUNT_ROLES
340: where party_id = p_customer_id
341: and current_role_state = 'A');
342:
343: /*

Line 345: from hz_cust_accounts r, hz_cust_account_roles s

341: and current_role_state = 'A');
342:
343: /*
344: select r.cust_account_id, r.account_number
345: from hz_cust_accounts r, hz_cust_account_roles s
346: where r.cust_account_id = s.cust_account_id
347: and s.current_role_state = 'A'
348: and s.party_id = p_customer_id
349: and r.party_id = p_company_id