APPS.PJI_SETUP_PKG dependencies on DUAL

Line 784: SELECT 1 FROM DUAL

780:
781:
782:
783: CURSOR C1 (c_bucket_set_code IN VARCHAR2) IS
784: SELECT 1 FROM DUAL
785: WHERE EXISTS (
786: SELECT 'X'
787: FROM pji_mt_buckets a,
788: pji_mt_buckets b

Line 796: SELECT 2 FROM DUAL

792: AND b.from_value < b.to_value
793: AND NVL(a.to_value, 99999999999999999999999) > b.to_value );
794:
795: CURSOR C2 (c_bucket_set_code IN VARCHAR2) IS
796: SELECT 2 FROM DUAL
797: WHERE EXISTS (
798: SELECT 'X'
799: FROM pji_mt_buckets a,
800: pji_mt_buckets b

Line 812: SELECT 3 FROM DUAL

808: WHERE c.from_value > a.to_value
809: AND c.to_value < b.from_value ));
810:
811: CURSOR C3 IS
812: SELECT 3 FROM DUAL
813: WHERE EXISTS (SELECT 'X'
814: FROM pji_mt_buckets a,
815: pji_mt_buckets b
816: WHERE a.bucket_set_code = b.bucket_set_code