APPS.IEM_EMAIL_ICNTR_MAPS_PVT dependencies on IEM_EMAIL_ACCOUNTS

Line 59: SELECT count(*) INTO l_grp_cnt FROM IEM_EMAIL_ACCOUNTS

55: -- Initialize API return status to SUCCESS
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57:
58: if p_email_account_id is not null THEN
59: SELECT count(*) INTO l_grp_cnt FROM IEM_EMAIL_ACCOUNTS
60: WHERE EMAIL_ACCOUNT_ID=p_email_account_id
61: and rownum=1;
62: IF l_grp_cnt = 0 then
63: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_EMAIL_ACCT_ID');

Line 303: SELECT count(*) INTO l_grp_cnt FROM IEM_EMAIL_ACCOUNTS

299: -- Initialize API return status to SUCCESS
300: x_return_status := FND_API.G_RET_STS_SUCCESS;
301:
302: if p_email_account_id <> FND_API.G_MISS_NUM THEN
303: SELECT count(*) INTO l_grp_cnt FROM IEM_EMAIL_ACCOUNTS
304: WHERE EMAIL_ACCOUNT_ID=p_email_account_id
305: and rownum=1;
306: IF l_grp_cnt = 0 then
307: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_EMAIL_ACCT_ID');