DBA Data[Home] [Help]

APPS.JTF_TERR_VALUES_PKG dependencies on JTF_TERR_VALUES_S

Line 41: CURSOR C2 IS SELECT JTF_TERR_VALUES_s.nextval FROM sys.dual;

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