APPS.JG_ZZ_TA_CC_RANGES_PKG dependencies on DUAL

Line 68: CURSOR C2 IS SELECT JG_ZZ_TA_CC_RANGES_S.nextval FROM sys.dual;

64: ,X_attribute15 VARCHAR2 ) IS
65: CURSOR C IS SELECT rowid
66: FROM JG_ZZ_TA_CC_RANGES
67: WHERE CC_RANGE_ID = X_cc_range_id;
68: CURSOR C2 IS SELECT JG_ZZ_TA_CC_RANGES_S.nextval FROM sys.dual;
69: CURSOR C4 IS SELECT JG_ZZ_TA_RULE_SETS_S.nextval FROM sys.dual;
70: CURSOR C3 IS SELECT 'FOUND'
71: FROM JG_ZZ_TA_CC_RANGES
72: WHERE RULE_SET_ID = X_rule_set_id

Line 69: CURSOR C4 IS SELECT JG_ZZ_TA_RULE_SETS_S.nextval FROM sys.dual;

65: CURSOR C IS SELECT rowid
66: FROM JG_ZZ_TA_CC_RANGES
67: WHERE CC_RANGE_ID = X_cc_range_id;
68: CURSOR C2 IS SELECT JG_ZZ_TA_CC_RANGES_S.nextval FROM sys.dual;
69: CURSOR C4 IS SELECT JG_ZZ_TA_RULE_SETS_S.nextval FROM sys.dual;
70: CURSOR C3 IS SELECT 'FOUND'
71: FROM JG_ZZ_TA_CC_RANGES
72: WHERE RULE_SET_ID = X_rule_set_id
73: AND CC_RANGE_LOW = X_cc_range_low