DBA Data[Home] [Help]

APPS.JG_ZZ_TA_ACCOUNT_RANGES_PKG dependencies on DUAL

Line 70: CURSOR C2 IS SELECT JG_ZZ_TA_ACCOUNT_RANGES_S.nextval FROM sys.dual;

66:
67: CURSOR C IS SELECT rowid
68: FROM JG_ZZ_TA_ACCOUNT_RANGES
69: WHERE X_account_range_id = account_range_id;
70: CURSOR C2 IS SELECT JG_ZZ_TA_ACCOUNT_RANGES_S.nextval FROM sys.dual;
71: BEGIN
72: IF (X_account_range_id IS NULL) THEN
73: OPEN C2;
74: FETCH C2 INTO X_account_range_id;