APPS.PJI_RESOURCE_UTILZ dependencies on PJI_RM_RES_F

Line 890: from pji_rm_res_f cur2, PJI_PMV_TIME_DIM_TMP pmv

886: DECODE(pmv.amount_type,1, cur2.total_hrs_a, cur2.conf_hrs_s)))) as exp_utilz,
887: 0 as prev_yr_utilz,
888: pmv.name as period_name,
889: pmv.order_by_id as id
890: from pji_rm_res_f cur2, PJI_PMV_TIME_DIM_TMP pmv
891: where person_id = p_person_id
892: and pmv.period_type IN (1,16)
893: and pmv.period_type = cur2.period_type_id
894: and pmv.calendar_type = 'C'

Line 913: from pji_rm_res_f cur2, PJI_PMV_TIME_DIM_TMP pmv

909: DECODE(pmv.amount_type,1, cur2.total_hrs_a, cur2.conf_hrs_s)))) as exp_utilz,
910: 0 as prev_yr_utilz,
911: pmv.name as period_name,
912: pmv.order_by_id as id
913: from pji_rm_res_f cur2, PJI_PMV_TIME_DIM_TMP pmv
914: where person_id = p_person_id
915: and pmv.period_type = 32
916: and pmv.period_type = cur2.period_type_id
917: and pmv.calendar_type = p_calendar_type

Line 931: from pji_rm_res_f cur2, PJI_PMV_TIME_DIM_TMP pmv

927: SUM(total_wtd_res_hrs_a)/DECODE(SUM(DECODE(g_calc_mthd,'CAPACITY',cur2.capacity_hrs - cur2.reduce_capacity_hrs_a, cur2.total_hrs_a)),
928: 0, null,SUM(DECODE(g_calc_mthd,'CAPACITY',cur2.capacity_hrs - cur2.reduce_capacity_hrs_a, cur2.total_hrs_a))) as prev_yr_utilz,
929: pmv.name as period_name,
930: pmv.order_by_id as id
931: from pji_rm_res_f cur2, PJI_PMV_TIME_DIM_TMP pmv
932: where person_id = p_person_id
933: and pmv.period_type = 32
934: and pmv.period_type = cur2.period_type_id
935: and pmv.calendar_type = p_calendar_type

Line 1155: FROM pji_rm_res_f cur2, PJI_PMV_TIME_DIM_TMP pmv

1151: DECODE(pmv.amount_type,1,cur2.reduce_capacity_hrs_a,cur2.reduce_capacity_hrs_s),
1152: DECODE(pmv.amount_type,1, cur2.total_hrs_a, cur2.conf_hrs_s)))) as exp_utilz,
1153: 0 as prev_yr_utilz,
1154: pmv.order_by_id as id
1155: FROM pji_rm_res_f cur2, PJI_PMV_TIME_DIM_TMP pmv
1156: WHERE person_id = p_person_id
1157: and pmv.period_type = cur2.period_type_id
1158: and pmv.calendar_type = cur2.calendar_type
1159: and pmv.id = cur2.time_id

Line 1170: from pji_rm_res_f cur2, PJI_PMV_TIME_DIM_TMP pmv

1166: 0 as exp_utilz,
1167: SUM(total_wtd_res_hrs_a)/DECODE(SUM(DECODE(g_calc_mthd,'CAPACITY',cur2.capacity_hrs - cur2.reduce_capacity_hrs_a, cur2.total_hrs_a)),
1168: 0, null,SUM(DECODE(g_calc_mthd,'CAPACITY',cur2.capacity_hrs - cur2.reduce_capacity_hrs_a, cur2.total_hrs_a))) as prev_yr_utilz,
1169: pmv.order_by_id as id
1170: from pji_rm_res_f cur2, PJI_PMV_TIME_DIM_TMP pmv
1171: where person_id = p_person_id
1172: and pmv.period_type = cur2.period_type_id
1173: and pmv.calendar_type = cur2.calendar_type
1174: and pmv.prior_id = cur2.time_id