APPS.JTF_PERZ_PROFILE_PVT dependencies on DUAL

Line 77: CURSOR C2 IS SELECT JTF_PERZ_PROFILE_S.NEXTVAL FROM SYS.DUAL;

73:
74: CURSOR C IS SELECT rowid FROM JTF_PERZ_PROFILE
75: WHERE PROFILE_ID = x_PROFILE_ID;
76:
77: CURSOR C2 IS SELECT JTF_PERZ_PROFILE_S.NEXTVAL FROM SYS.DUAL;
78:
79: BEGIN
80:
81: IF (X_PROFILE_ID IS NULL) OR ( X_PROFILE_ID = FND_API.G_MISS_NUM) THEN

Line 166: CURSOR C2 IS SELECT jtf_perz_profile_attrib_s.NEXTVAL FROM SYS.DUAL;

162: ) IS
163:
164: CURSOR C IS SELECT rowid FROM jtf_perz_profile_attrib
165: WHERE PROFILE_ID = x_PROFILE_ID AND ROWNUM = 1;
166: CURSOR C2 IS SELECT jtf_perz_profile_attrib_s.NEXTVAL FROM SYS.DUAL;
167:
168: BEGIN
169: IF (X_PROFILE_ATTRIB_ID IS NULL) OR
170: (X_PROFILE_ATTRIB_ID = FND_API.G_MISS_NUM) THEN