DBA Data[Home] [Help]

APPS.AMS_LIST_ENTRIES_PVT dependencies on DUAL

Line 1879: FROM dual;

1875: l_created_by NUMBER; --batoleti added this var. For bug# 6688996
1876:
1877: CURSOR c_id IS
1878: SELECT AMS_LIST_ENTRIES_s.NEXTVAL
1879: FROM dual;
1880:
1881: CURSOR c_id_exists (l_id IN NUMBER) IS
1882: SELECT 1 FROM dual
1883: WHERE EXISTS (SELECT 1 FROM AMS_LIST_ENTRIES

Line 1882: SELECT 1 FROM dual

1878: SELECT AMS_LIST_ENTRIES_s.NEXTVAL
1879: FROM dual;
1880:
1881: CURSOR c_id_exists (l_id IN NUMBER) IS
1882: SELECT 1 FROM dual
1883: WHERE EXISTS (SELECT 1 FROM AMS_LIST_ENTRIES
1884: WHERE LIST_ENTRY_ID = l_id);
1885:
1886: /* batoleti. Bug# 6688996. Added the below cursor */