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 697: FROM PJI_MT_MEASURES_B

693: INTO
694: x_measure_set_codes_tbl(i)
695: ,x_timeslices_tbl(i)
696: ,x_measure_id_tbl(i)
697: FROM PJI_MT_MEASURES_B
698: WHERE measure_code = p_measure_codes_tbl(i);
699:
700: EXCEPTION
701: WHEN NO_DATA_FOUND THEN

Line 886: FROM PJI_MT_MEASURES_B

882: INTO
883: l_measure_set_codes_tbl(i)
884: ,l_timeslices_tbl(i)
885: ,l_measure_id_tbl(i)
886: FROM PJI_MT_MEASURES_B
887: WHERE measure_code = p_measure_codes_tbl(i);
888:
889: EXCEPTION
890: WHEN NO_DATA_FOUND THEN

Line 3317: pji_mt_measures_b m,

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