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_CAL_PERIOD_V

Line 2406: pji_time_cal_period_V

2402: ,0 itd_mask
2403: ,0 ac_mask
2404: ,1 prp_mask
2405: FROM
2406: pji_time_cal_period_V
2407: WHERE 1=1
2408: --this is the first date of the period - 1 day, so I get the previous period, otherwise i'd get the curr. period
2409: AND TO_DATE(pPeriodDateJulian,l_julianFormat)-1 BETWEEN start_date AND end_date
2410: AND calendar_id = pCalendarId

Line 3059: pji_time_cal_period_V

3055: ,0 itd_mask
3056: ,0 ac_mask
3057: ,1 prp_mask
3058: FROM
3059: pji_time_cal_period_V
3060: WHERE 1=1
3061: AND TO_DATE(pPeriodDateJulian,l_julianFormat)-1 BETWEEN start_date AND end_date -- report_date
3062: AND calendar_id = pCalendarId
3063: AND pCalendarType <> l_calendarType_E

Line 3216: FROM pji_time_cal_period_v

3212: AND TO_DATE(pPeriodDateJulian,'j') BETWEEN start_date AND end_date
3213: AND pCalendarType = 'E'
3214: UNION ALL
3215: SELECT end_date
3216: FROM pji_time_cal_period_v
3217: WHERE 1=1
3218: AND (TO_DATE(pPeriodDateJulian,'j') BETWEEN start_date AND end_date)
3219: AND calendar_id = pCalendarId
3220: AND pCalendarType <> 'E'

Line 3245: FROM pji_time_cal_period_v

3241: AND TO_DATE(pPeriodDateJulian,'j') BETWEEN start_date AND end_date
3242: AND pCalendarType = 'E'
3243: UNION ALL
3244: SELECT (end_date - start_date+1) days
3245: FROM pji_time_cal_period_v
3246: WHERE 1=1
3247: AND (TO_DATE(pPeriodDateJulian,'j') BETWEEN start_date AND end_date)
3248: AND calendar_id = pCalendarId
3249: AND pCalendarType <> 'E'