APPS.JTF_TERR_VALUES_PKG dependencies on JTF_TERR_VALUES_S
Line 40: CURSOR C2 IS SELECT JTF_TERR_VALUES_s.nextval FROM sys.dual;
36: x_VALUE4_ID IN NUMBER
37: ) IS
38: CURSOR C IS SELECT rowid FROM JTF_TERR_VALUES_ALL
39: WHERE TERR_VALUE_ID = x_TERR_VALUE_ID; 40: CURSOR C2 IS SELECT JTF_TERR_VALUES_s.nextval FROM sys.dual; 41: BEGIN
42: If (x_TERR_VALUE_ID IS NULL) then
43: OPEN C2;
44: FETCH C2 INTO x_TERR_VALUE_ID;