APPS.PJI_REP_MEASURE_UTIL dependencies on PJI_MT_MEASURE_SETS_B

Line 3318: pji_mt_measure_sets_b S

3314: , ac_measure_ids_tbl
3315: , prp_measure_ids_tbl
3316: FROM
3317: pji_mt_measures_b m,
3318: pji_mt_measure_sets_b S
3319: WHERE 1=1
3320: AND m.measure_set_code = S.measure_set_code
3321: AND S.measure_set_type IN ('SEEDED', 'CUSTOM_STORED', 'CUSTOM_CALC')
3322: AND m.measure_set_code LIKE 'PPF%'

Line 4150: FROM pji_mt_measure_sets_b

4146: l_ac_cus_meas_formats := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4147: BEGIN
4148: SELECT measure_format
4149: BULK COLLECT INTO l_fp_cus_meas_formats
4150: FROM pji_mt_measure_sets_b
4151: WHERE 1=1
4152: AND measure_set_type IN ('CUSTOM_CALC','CUSTOM_STORED')
4153: AND measure_source = 'FP'
4154: ORDER BY TO_NUMBER(SUBSTR(measure_set_code,16,2));

Line 4158: FROM pji_mt_measure_sets_b

4154: ORDER BY TO_NUMBER(SUBSTR(measure_set_code,16,2));
4155:
4156: SELECT measure_format
4157: BULK COLLECT INTO l_ac_cus_meas_formats
4158: FROM pji_mt_measure_sets_b
4159: WHERE 1=1
4160: AND measure_set_type IN ('CUSTOM_CALC','CUSTOM_STORED')
4161: AND measure_source = 'AC'
4162: ORDER BY TO_NUMBER(SUBSTR(measure_set_code,16,2));