APPS.PJI_REP_MEASURE_UTIL dependencies on PJI_MT_MEASURE_SETS_B

Line 3311: pji_mt_measure_sets_b S

3307: , ac_measure_ids_tbl
3308: , prp_measure_ids_tbl
3309: FROM
3310: pji_mt_measures_b m,
3311: pji_mt_measure_sets_b S
3312: WHERE 1=1
3313: AND m.measure_set_code = S.measure_set_code
3314: AND S.measure_set_type IN ('SEEDED', 'CUSTOM_STORED', 'CUSTOM_CALC')
3315: AND m.measure_set_code LIKE 'PPF%'

Line 4131: FROM pji_mt_measure_sets_b

4127: l_ac_cus_meas_formats := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4128: BEGIN
4129: SELECT measure_format
4130: BULK COLLECT INTO l_fp_cus_meas_formats
4131: FROM pji_mt_measure_sets_b
4132: WHERE 1=1
4133: AND measure_set_type IN ('CUSTOM_CALC','CUSTOM_STORED')
4134: AND measure_source = 'FP'
4135: ORDER BY TO_NUMBER(SUBSTR(measure_set_code,16,2));

Line 4139: FROM pji_mt_measure_sets_b

4135: ORDER BY TO_NUMBER(SUBSTR(measure_set_code,16,2));
4136:
4137: SELECT measure_format
4138: BULK COLLECT INTO l_ac_cus_meas_formats
4139: FROM pji_mt_measure_sets_b
4140: WHERE 1=1
4141: AND measure_set_type IN ('CUSTOM_CALC','CUSTOM_STORED')
4142: AND measure_source = 'AC'
4143: ORDER BY TO_NUMBER(SUBSTR(measure_set_code,16,2));