APPS.FUN_RECIPIENT_WF dependencies on DUAL

Line 928: SELECT REPLACE(l_user_email, 'email:') INTO l_user_email FROM dual;

924: THEN
925: -- Get the user email from wf_engine.context_text
926: l_user_email := wf_engine.context_user;
927:
928: SELECT REPLACE(l_user_email, 'email:') INTO l_user_email FROM dual;
929:
930: IF l_user_email IS NOT NULL
931: THEN
932: OPEN c_get_email_userid (l_user_email);

Line 2263: SELECT FUN_DIST_LINES_S.nextval INTO l_dist_id FROM dual;

2259: LOOP
2260:
2261:
2262:
2263: SELECT FUN_DIST_LINES_S.nextval INTO l_dist_id FROM dual;
2264:
2265: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2266: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.recipient_interco_acct', 'Inserting distribution ' || l_dist_id);
2267: END IF;

Line 3327: FROM dual;

3323: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'Build the initiator distribution lines');
3324: END IF;
3325: SELECT FUN_DIST_LINES_S.nextval
3326: INTO l_new_dist_tbl(l_new_index).dist_id
3327: FROM dual;
3328:
3329: l_new_dist_tbl(l_new_index).line_id := l_init_dist_tbl(1).line_id;
3330: l_new_dist_tbl(l_new_index).trx_id := l_init_dist_tbl(1).trx_id;
3331: l_new_dist_tbl(l_new_index).dist_number := l_new_dist_tbl(l_new_index).dist_id;

Line 3770: FROM dual;

3766: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_interco_acct', 'Build the Distribution lines');
3767: END IF;
3768: SELECT FUN_DIST_LINES_S.nextval
3769: INTO l_new_dist_tbl(l_new_index).dist_id
3770: FROM dual;
3771:
3772: l_new_dist_tbl(l_new_index).line_id := l_reci_dist_tbl(1).line_id;
3773: l_new_dist_tbl(l_new_index).trx_id := l_reci_dist_tbl(1).trx_id;
3774: l_new_dist_tbl(l_new_index).dist_number := l_new_dist_tbl(l_new_index).dist_id;