APPS.IBU_HOME_PAGE_PVT dependencies on HZ_CUST_ACCOUNTS

Line 314: from HZ_CUST_ACCOUNTS

310: l_cind NUMBER := 1;
311:
312: CURSOR acct_info_b2c(p_customer_id IN NUMBER) IS
313: select cust_account_id, account_number
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

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 334: from HZ_CUST_ACCOUNTS

330: */
331:
332: CURSOR acct_info_b2b(p_customer_id IN NUMBER, p_company_id IN NUMBER) IS
333: select cust_account_id, account_number
334: from HZ_CUST_ACCOUNTS
335: where status = 'A'
336: and party_id = p_company_id
337: and cust_account_id in
338: (select cust_account_id

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