DBA Data[Home] [Help]

APPS.JTF_PERZ_QUERY_PVT dependencies on JTF_PERZ_QUERY_PARAM_S

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;