APPS.JTF_PERZ_QUERY_PVT dependencies on DUAL

Line 97: CURSOR C2 IS SELECT JTF_PERZ_QUERY_S.NEXTVAL FROM sys.dual;

93: ) IS
94: CURSOR C IS SELECT ROWID FROM JTF_PERZ_QUERY
95: WHERE QUERY_ID = x_QUERY_ID;
96:
97: CURSOR C2 IS SELECT JTF_PERZ_QUERY_S.NEXTVAL FROM sys.dual;
98:
99: BEGIN
100: IF ((x_QUERY_ID IS NULL) OR
101: (x_QUERY_ID = Fnd_Api.G_MISS_NUM)) THEN

Line 152: CURSOR C2 IS SELECT JTF_PERZ_QUERY_ORDER_BY_s.NEXTVAL FROM sys.dual;

148: ) IS
149: CURSOR C IS SELECT ROWID FROM JTF_PERZ_QUERY_ORDER_BY
150: WHERE QUERY_ORDER_BY_ID = x_QUERY_ORDER_BY_ID;
151:
152: CURSOR C2 IS SELECT JTF_PERZ_QUERY_ORDER_BY_s.NEXTVAL FROM sys.dual;
153:
154: BEGIN
155: IF (x_QUERY_ORDER_BY_ID IS NULL) THEN
156: OPEN C2;

Line 203: CURSOR C2 IS SELECT JTF_PERZ_QUERY_RAW_SQL_s.NEXTVAL FROM sys.dual;

199: X_Having_String VARCHAR2
200: ) IS
201: CURSOR C IS SELECT ROWID FROM JTF_PERZ_QUERY_RAW_SQL
202: WHERE Query_Raw_Sql_ID = X_Query_Raw_Sql_ID;
203: CURSOR C2 IS SELECT JTF_PERZ_QUERY_RAW_SQL_s.NEXTVAL FROM sys.dual;
204:
205: BEGIN
206: IF ((X_Query_Raw_Sql_ID IS NULL) OR
207: (X_Query_Raw_Sql_ID = Fnd_Api.G_MISS_NUM ))THEN

Line 257: CURSOR C2 IS SELECT JTF_PERZ_QUERY_PARAM_s.NEXTVAL FROM sys.dual;

253: X_Parameter_sequence VARCHAR2
254: ) IS
255: CURSOR C IS SELECT ROWID FROM JTF_PERZ_QUERY_PARAM
256: WHERE query_param_id = X_query_param_id;
257: CURSOR C2 IS SELECT JTF_PERZ_QUERY_PARAM_s.NEXTVAL FROM sys.dual;
258: BEGIN
259: IF ((X_query_param_id IS NULL) OR
260: (X_query_param_id = Fnd_Api.G_MISS_NUM)) THEN
261: OPEN C2;