eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_REP_MEASURE_UTIL dependencies on PJI_TIME_ENT_PERIOD_V

Line 2428: pji_time_ent_period_V

2424: ,0 itd_mask
2425: ,0 ac_mask
2426: ,1 prp_mask
2427: FROM
2428: pji_time_ent_period_V
2429: WHERE 1=1
2430: AND TO_DATE(pPeriodDateJulian,l_julianFormat)-1 BETWEEN start_date AND end_date
2431: AND pCalendarType = l_calendarType_E
2432: ) TIME

Line 3080: pji_time_ent_period_V

3076: ,0 itd_mask
3077: ,0 ac_mask
3078: ,1 prp_mask
3079: FROM
3080: pji_time_ent_period_V
3081: WHERE 1=1
3082: AND TO_DATE(pPeriodDateJulian,l_julianFormat)-1 BETWEEN start_date AND end_date -- report_date
3083: AND pCalendarType = l_calendarType_E
3084: ) TIME

Line 3217: FROM pji_time_ent_period_v

3213: xDaysSinceITD
3214: , l_org_id
3215: FROM pa_projects_all,
3216: ( SELECT end_date
3217: FROM pji_time_ent_period_v
3218: WHERE 1=1
3219: AND TO_DATE(pPeriodDateJulian,'j') BETWEEN start_date AND end_date
3220: AND pCalendarType = 'E'
3221: UNION ALL

Line 3246: FROM pji_time_ent_period_v

3242: SELECT days
3243: INTO xDaysInPeriod
3244: FROM (
3245: SELECT (end_date - start_date+1) days
3246: FROM pji_time_ent_period_v
3247: WHERE 1=1
3248: AND TO_DATE(pPeriodDateJulian,'j') BETWEEN start_date AND end_date
3249: AND pCalendarType = 'E'
3250: UNION ALL