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_UTIL dependencies on PJI_TIME_CAL_PERIOD_V

Line 2272: FROM pji_time_cal_period_v

2268: ELSE
2269:
2270: SELECT COUNT(*)
2271: INTO l_rec_count
2272: FROM pji_time_cal_period_v
2273: WHERE start_date >= l_start_date
2274: AND end_date <= l_end_date
2275: AND calendar_id = p_calendar_id;
2276:

Line 2287: x_slice_name := 'PJI_TIME_CAL_PERIOD_V';

2283: AND end_date <= l_end_date
2284: AND calendar_id = p_calendar_id;
2285:
2286: IF l_rec_count <= 1 THEN
2287: x_slice_name := 'PJI_TIME_CAL_PERIOD_V';
2288: ELSIF l_rec_count > 12 THEN
2289:
2290: SELECT COUNT(*)
2291: INTO l_rec_count

Line 2306: x_slice_name := 'PJI_TIME_CAL_PERIOD_V';

2302: ELSE
2303: x_slice_name := 'PJI_TIME_CAL_QTR_V';
2304: END IF;
2305: ELSE
2306: x_slice_name := 'PJI_TIME_CAL_PERIOD_V';
2307: END IF;
2308:
2309: END IF;
2310:

Line 2869: pji_time_cal_period_v TIM

2865: if l_same_pa_gl_period = 'Y' then /* Added for bug 9859878 */
2866: SELECT MIN(TIM.start_date) first_open
2867: INTO l_report_date
2868: FROM
2869: pji_time_cal_period_v TIM
2870: , gl_period_statuses glps
2871: , pa_implementations paimp
2872: WHERE 1=1
2873: AND TIM.calendar_id = x_calendar_id

Line 2882: pji_time_cal_period_v TIM

2878: else /* Added for bug 9859878 */
2879: SELECT MIN(TIM.start_date) first_open
2880: INTO l_report_date
2881: FROM
2882: pji_time_cal_period_v TIM
2883: , pa_periods_all pa
2884: , pa_implementations paimp
2885: WHERE 1=1
2886: AND TIM.calendar_id = x_calendar_id

Line 2896: pji_time_cal_period_v TIM

2892: if l_same_pa_gl_period = 'Y' then /* Added for bug 9859878 */
2893: SELECT MAX(TIM.start_date) last_open
2894: INTO l_report_date
2895: FROM
2896: pji_time_cal_period_v TIM
2897: , gl_period_statuses glps
2898: , pa_implementations paimp
2899: WHERE 1=1
2900: AND TIM.calendar_id = x_calendar_id

Line 2909: pji_time_cal_period_v TIM

2905: else /* Added for bug 9859878 */
2906: SELECT MAX(TIM.start_date) last_open
2907: INTO l_report_date
2908: FROM
2909: pji_time_cal_period_v TIM
2910: , pa_periods_all pa
2911: , pa_implementations paimp
2912: WHERE 1=1
2913: AND TIM.calendar_id = x_calendar_id

Line 2923: pji_time_cal_period_v TIM

2919: if l_same_pa_gl_period = 'Y' then /* Added for bug 9859878 */
2920: SELECT MAX(TIM.start_date) last_closed
2921: INTO l_report_date
2922: FROM
2923: pji_time_cal_period_v TIM
2924: , gl_period_statuses glps
2925: , pa_implementations paimp
2926: WHERE 1=1
2927: AND TIM.calendar_id = x_calendar_id

Line 2936: pji_time_cal_period_v TIM

2932: else /* Added for bug 9859878 */
2933: SELECT MAX(TIM.start_date) last_open
2934: INTO l_report_date
2935: FROM
2936: pji_time_cal_period_v TIM
2937: , pa_periods_all pa
2938: , pa_implementations paimp
2939: WHERE 1=1
2940: AND TIM.calendar_id = x_calendar_id

Line 2949: FROM pji_time_cal_period_v

2945:
2946: ELSIF l_active_rep IN ('CURRENT','PRIOR') THEN
2947: SELECT start_date
2948: INTO l_report_date
2949: FROM pji_time_cal_period_v
2950: WHERE TRUNC(SYSDATE) BETWEEN start_date
2951: AND end_date
2952: AND calendar_id = x_calendar_id;
2953: END IF;

Line 2958: FROM pji_time_cal_period_v

2954:
2955: IF l_active_rep = 'PRIOR' THEN
2956: SELECT MAX(start_date)
2957: INTO l_report_date
2958: FROM pji_time_cal_period_v
2959: WHERE end_date < l_report_date
2960: AND calendar_id = x_calendar_id;
2961: END IF;
2962:

Line 2968: FROM pji_time_cal_period_v

2964: l_period_name := l_specific_period;
2965:
2966: SELECT start_date
2967: INTO l_report_date
2968: FROM pji_time_cal_period_v
2969: WHERE name = l_period_name
2970: AND calendar_id = x_calendar_id;
2971: ELSE
2972: SELECT name

Line 2974: FROM pji_time_cal_period_v

2970: AND calendar_id = x_calendar_id;
2971: ELSE
2972: SELECT name
2973: INTO l_period_name
2974: FROM pji_time_cal_period_v
2975: WHERE l_report_date BETWEEN start_date AND end_date
2976: AND calendar_id = x_calendar_id;
2977: END IF;
2978: END IF;

Line 6013: FROM pji_time_cal_period_v

6009: WHERE TO_DATE(p_as_of_date, 'j') BETWEEN start_date AND end_date;
6010: ELSE
6011: SELECT name,TO_CHAR(start_date,'j')
6012: INTO x_period_name, x_report_date_julian
6013: FROM pji_time_cal_period_v
6014: WHERE calendar_id = x_calendar_id
6015: AND TO_DATE(p_as_of_date,'j') BETWEEN start_date AND end_date;
6016: END IF;
6017: