APPS.JTF_PERZ_LF_PVT dependencies on DUAL

Line 188: CURSOR C2 IS SELECT JTF_PERZ_OBJ_MAP_s.nextval FROM sys.dual;

184: x_OBJECT_ID IN NUMBER
185: ) IS
186: CURSOR C IS SELECT rowid FROM JTF_PERZ_OBJ_MAP
187: WHERE OBJ_MAP_ID = x_OBJ_MAP_ID;
188: CURSOR C2 IS SELECT JTF_PERZ_OBJ_MAP_s.nextval FROM sys.dual;
189: BEGIN
190: If (x_OBJ_MAP_ID IS NULL) then
191: OPEN C2;
192: FETCH C2 INTO x_OBJ_MAP_ID;

Line 230: CURSOR C2 IS SELECT JTF_PERZ_LF_VALUE_s.nextval FROM sys.dual;

226: x_PRIORITY IN NUMBER
227: ) IS
228: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_VALUE
229: WHERE PERZ_LF_VALUE_ID = x_VALUE_ID;
230: CURSOR C2 IS SELECT JTF_PERZ_LF_VALUE_s.nextval FROM sys.dual;
231:
232:
233: BEGIN
234:

Line 278: CURSOR C2 IS SELECT jtf_perz_obj_type_map_s.nextval FROM sys.dual;

274: x_ATTRIBUTE_ID IN NUMBER
275: ) IS
276: CURSOR C IS SELECT rowid FROM jtf_perz_obj_type_map
277: WHERE obj_type_map_id = x_MAP_ID;
278: CURSOR C2 IS SELECT jtf_perz_obj_type_map_s.nextval FROM sys.dual;
279: BEGIN
280: If (x_MAP_ID IS NULL) then
281: OPEN C2;
282: FETCH C2 INTO x_MAP_ID;

Line 340: CURSOR C2 IS SELECT JTF_PERZ_LF_ATTRIB_s.nextval FROM sys.dual;

336:
337: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_ATTRIB
338: WHERE ATTRIBUTE_ID = x_ATTRIBUTE_ID;
339:
340: CURSOR C2 IS SELECT JTF_PERZ_LF_ATTRIB_s.nextval FROM sys.dual;
341:
342: BEGIN
343:
344: If (x_ATTRIBUTE_ID IS NULL) then

Line 385: CURSOR C2 IS SELECT JTF_PERZ_LF_OBJ_TYPE_s.nextval FROM sys.dual;

381: ) IS
382:
383: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_OBJECT_TYPE
384: WHERE OBJECT_TYPE_ID = x_OBJECT_TYPE_ID;
385: CURSOR C2 IS SELECT JTF_PERZ_LF_OBJ_TYPE_s.nextval FROM sys.dual;
386:
387: BEGIN
388:
389: If (x_OBJECT_TYPE_ID IS NULL) then

Line 435: CURSOR C2 IS SELECT JTF_PERZ_LF_OBJECT_s.nextval FROM sys.dual;

431: ) IS
432:
433: CURSOR C IS SELECT rowid FROM JTF_PERZ_LF_OBJECT
434: WHERE OBJECT_ID = x_OBJECT_ID;
435: CURSOR C2 IS SELECT JTF_PERZ_LF_OBJECT_s.nextval FROM sys.dual;
436:
437: BEGIN
438:
439: If (x_OBJECT_ID IS NULL) then