APPS.PJI_RM_SUM_AVL dependencies on PJI_MT_BUCKETS

Line 81: FROM pji_mt_buckets pmb

77: pmb.to_value
78: BULK COLLECT INTO
79: l_min_bucket_tbl,
80: l_max_bucket_tbl
81: FROM pji_mt_buckets pmb
82: WHERE pmb.bucket_set_code = 'PJI_RES_AVL_DAYS'
83: ORDER BY pmb.seq;
84:
85: g_bucket_1_min := l_min_bucket_tbl(1);

Line 100: FROM PJI_MT_BUCKETS

96:
97: --Get the number of thresholds being used in the system set up
98: SELECT count(*)
99: INTO g_no_of_user_def_threshold
100: FROM PJI_MT_BUCKETS
101: WHERE BUCKET_SET_CODE = 'PJI_RESOURCE_AVAILABILITY';
102:
103: --Get the minimum of julian start day from fii_time_day
104: SELECT MIN(to_char(fiik.start_date,'j'))