APPS.PA_PROJECT_REQUEST_PVT dependencies on DUAL

Line 1879: FROM dual;

1875: --Generate group_id for each run of update projects.
1876: --Used by workflow notification.
1877: SELECT pa_wf_ntf_performers_s.nextval
1878: INTO l_group_id
1879: FROM dual;
1880:
1881: -- Added by Sachin for P1 bug 3765557
1882: --changed for P1 Bug6727240
1883: l_guest_user := null;

Line 1886: from dual;

1882: --changed for P1 Bug6727240
1883: l_guest_user := null;
1884: SELECT SUBSTRB(FND_WEB_SEC.GET_GUEST_USERNAME_PWD,1,INSTRB(FND_WEB_SEC.GET_GUEST_USERNAME_PWD, '/' )-1)
1885: into l_guest_user
1886: from dual;
1887: --changed for P1 Bug6727240
1888: -- End bug 3765557
1889:
1890: IF (p_is_profile_defined = 'N') THEN

Line 2359: FROM DUAL;

2355: IF (l_recipient_tab(i) <> l_last_recipient AND l_last_recipient <> TEXT_DUMMY) THEN
2356:
2357: SELECT PA_PRM_WF_ITEM_KEY_S.nextval
2358: INTO l_item_key
2359: FROM DUAL;
2360:
2361: debug('l_item_key(inside loop) = ' || l_item_key);
2362:
2363:

Line 2441: FROM DUAL;

2437: IF l_recipient_tab.count <> 0 THEN
2438: -- Sent notification for the last recipient.
2439: SELECT PA_PRM_WF_ITEM_KEY_S.nextval
2440: INTO l_item_key
2441: FROM DUAL;
2442: debug('l_item_key(outside loop) = ' || l_item_key);
2443:
2444: -- Create the WF process
2445: WF_ENGINE.CreateProcess ( ItemType => l_item_type,