APPS.CN_QUOTA_ASSIGNS_PKG dependencies on DUAL

Line 46: FROM sys.dual;

42: BEGIN
43:
44: SELECT cn_quota_assigns_s.nextval
45: INTO X_Quota_Assign_Id
46: FROM sys.dual;
47:
48: END get_uid;
49:
50: -- Name

Line 523: SELECT 1 INTO X_dummy FROM sys.dual

519:
520: PROCEDURE Check_exists( X_Quota_Id NUMBER) IS
521: X_Dummy NUMBER;
522: BEGIN
523: SELECT 1 INTO X_dummy FROM sys.dual
524: WHERE EXISTS ( SELECT 1
525: FROM cn_quotas
526: WHERE quota_id = X_quota_id)
527: ;

Line 552: FROM sys.dual

548:
549: BEGIN
550: SELECT 1
551: INTO x_dummy
552: FROM sys.dual
553: WHERE NOT EXISTS (
554: SELECT 1
555: FROM cn_quota_assigns
556: WHERE quota_id = x_quota_id