DBA Data[Home] [Help]

APPS.JTF_PERZ_QUERY_PVT dependencies on JTF_PERZ_QUERY_ORDER_BY_S

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;