APPS.IEM_EMAIL_PROC_PVT dependencies on HZ_CUST_ACCOUNTS

Line 6892: from hz_cust_accounts

6888: iem_logger(l_logmessage);
6889: --dbms_output.put_line(l_logmessage);
6890: BEGIN
6891: select cust_account_id into l_cust_account_id
6892: from hz_cust_accounts
6893: where party_id =g_customer_id;
6894: EXCEPTION
6895: when TOO_MANY_ROWS then
6896: l_logmessage:='p_account_id fetch before sr creation too many rows'|| SQL%ROWCOUNT;

Line 7340: from hz_cust_accounts

7336:
7337: ELSIF p_account_number is not null then
7338: BEGIN
7339: select party_id into x_customer_id
7340: from hz_cust_accounts
7341: where account_number=p_account_number;
7342: EXCEPTION
7343: when TOO_MANY_ROWS then
7344: x_customer_id := null;

Line 7731: from hz_cust_accounts

7727: IF (g_customer_id IS NOT NULL) AND (p_account_number IS NOT NULL) THEN
7728: BEGIN
7729: --the status must be active for cust_account_id
7730: Select cust_account_id into x_cust_account_id
7731: from hz_cust_accounts
7732: where party_id=g_customer_id
7733: and account_number=p_account_number
7734: and status = 'A';
7735: EXCEPTION

Line 7754: from hz_cust_accounts

7750: -- try to find account_number related info even if there is no customer_id
7751: ELSE
7752: BEGIN
7753: Select cust_account_id into x_cust_account_id
7754: from hz_cust_accounts
7755: where account_number=p_account_number
7756: and status = 'A';
7757: EXCEPTION
7758: when TOO_MANY_ROWS then

Line 9032: from hz_cust_accounts

9028:
9029: --addd validation for getting x_account_id
9030: BEGIN
9031: select cust_account_id into x_account_id
9032: from hz_cust_accounts
9033: where party_id = p_customer_id
9034: AND status = 'A';
9035:
9036: l_logmessage:='cust_account_id id is: '|| x_account_id ;