DBA Data[Home] [Help]

APPS.PV_PG_NOTIF_UTILITY_PVT dependencies on DUAL

Line 647: SELECT fnd_web_config.jsp_agent FROM dual;

643: RETURN VARCHAR2
644: IS
645: /* Get the web server jsp agent. */
646: CURSOR c_jsp_agent IS
647: SELECT fnd_web_config.jsp_agent FROM dual;
648:
649: /* Get the function url. */
650: CURSOR c_function_url IS
651: SELECT web_html_call

Line 4961: FROM dual;

4957: x_return_status := FND_API.G_RET_STS_SUCCESS ;
4958:
4959: SELECT PV_LEAD_WORKFLOWS_S.nextval
4960: INTO l_val
4961: FROM dual;
4962: l_itemKey := l_itemKey || l_val;
4963: -- check for null
4964: /**
4965: IF ( p_context_code = FND_API.G_MISS_CHAR OR p_context_code IS NULL ) THEN

Line 5783: FROM dual;

5779: x_return_status := FND_API.G_RET_STS_SUCCESS ;
5780:
5781: SELECT PV_LEAD_WORKFLOWS_S.nextval
5782: INTO l_val
5783: FROM dual;
5784:
5785: l_itemKey := l_itemKey || l_val;
5786: /* Get the user list */
5787: get_users_list