DBA Data[Home] [Help]

APPS.PJI_REP_MEASURE_UTIL dependencies on PJI_MT_MEASURES_B

Line 280: , pji_mt_measures_b msrs

276: , l_xtd_types_tbl
277: , l_measure_values_tbl --will contain the values for the requested measures
278: FROM
279: pa_perf_temp_obj_measure excp
280: , pji_mt_measures_b msrs
281: WHERE 1=1
282: AND excp.object_type = 'PA_PROJECTS'
283: AND msrs.measure_id = excp.measure_id
284: AND excp.object_id = l_project_ids_tbl(i)

Line 690: FROM PJI_MT_MEASURES_B

686: INTO
687: x_measure_set_codes_tbl(i)
688: ,x_timeslices_tbl(i)
689: ,x_measure_id_tbl(i)
690: FROM PJI_MT_MEASURES_B
691: WHERE measure_code = p_measure_codes_tbl(i);
692:
693: EXCEPTION
694: WHEN NO_DATA_FOUND THEN

Line 879: FROM PJI_MT_MEASURES_B

875: INTO
876: l_measure_set_codes_tbl(i)
877: ,l_timeslices_tbl(i)
878: ,l_measure_id_tbl(i)
879: FROM PJI_MT_MEASURES_B
880: WHERE measure_code = p_measure_codes_tbl(i);
881:
882: EXCEPTION
883: WHEN NO_DATA_FOUND THEN

Line 3310: pji_mt_measures_b m,

3306: , itd_measure_ids_tbl
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')