APPS.PJI_REP_UTIL dependencies on PJI_TIME_CAL_PERIOD_V

Line 1882: FROM pji_time_cal_period_v

1878: ELSE
1879:
1880: SELECT COUNT(*)
1881: INTO l_rec_count
1882: FROM pji_time_cal_period_v
1883: WHERE start_date >= l_start_date
1884: AND end_date <= l_end_date
1885: AND calendar_id = p_calendar_id;
1886:

Line 1897: x_slice_name := 'PJI_TIME_CAL_PERIOD_V';

1893: AND end_date <= l_end_date
1894: AND calendar_id = p_calendar_id;
1895:
1896: IF l_rec_count <= 1 THEN
1897: x_slice_name := 'PJI_TIME_CAL_PERIOD_V';
1898: ELSIF l_rec_count > 12 THEN
1899:
1900: SELECT COUNT(*)
1901: INTO l_rec_count

Line 1916: x_slice_name := 'PJI_TIME_CAL_PERIOD_V';

1912: ELSE
1913: x_slice_name := 'PJI_TIME_CAL_QTR_V';
1914: END IF;
1915: ELSE
1916: x_slice_name := 'PJI_TIME_CAL_PERIOD_V';
1917: END IF;
1918:
1919: END IF;
1920:

Line 2467: pji_time_cal_period_v TIM

2463: IF l_active_rep ='FIRST_OPEN' THEN
2464: SELECT MIN(TIM.start_date) first_open
2465: INTO l_report_date
2466: FROM
2467: pji_time_cal_period_v TIM
2468: , gl_period_statuses glps
2469: , pa_implementations paimp
2470: WHERE 1=1
2471: AND TIM.calendar_id = x_calendar_id

Line 2480: pji_time_cal_period_v TIM

2476: ELSIF l_active_rep = 'LAST_OPEN' THEN
2477: SELECT MAX(TIM.start_date) last_open
2478: INTO l_report_date
2479: FROM
2480: pji_time_cal_period_v TIM
2481: , gl_period_statuses glps
2482: , pa_implementations paimp
2483: WHERE 1=1
2484: AND TIM.calendar_id = x_calendar_id

Line 2493: pji_time_cal_period_v TIM

2489: ELSIF l_active_rep = 'LAST_CLOSED' THEN
2490: SELECT MAX(TIM.start_date) last_closed
2491: INTO l_report_date
2492: FROM
2493: pji_time_cal_period_v TIM
2494: , gl_period_statuses glps
2495: , pa_implementations paimp
2496: WHERE 1=1
2497: AND TIM.calendar_id = x_calendar_id

Line 2505: FROM pji_time_cal_period_v

2501: AND closing_status = 'C';
2502: ELSIF l_active_rep IN ('CURRENT','PRIOR') THEN
2503: SELECT start_date
2504: INTO l_report_date
2505: FROM pji_time_cal_period_v
2506: WHERE TRUNC(SYSDATE) BETWEEN start_date
2507: AND end_date
2508: AND calendar_id = x_calendar_id;
2509: END IF;

Line 2514: FROM pji_time_cal_period_v

2510:
2511: IF l_active_rep = 'PRIOR' THEN
2512: SELECT MAX(start_date)
2513: INTO l_report_date
2514: FROM pji_time_cal_period_v
2515: WHERE end_date < l_report_date
2516: AND calendar_id = x_calendar_id;
2517: END IF;
2518:

Line 2524: FROM pji_time_cal_period_v

2520: l_period_name := l_specific_period;
2521:
2522: SELECT start_date
2523: INTO l_report_date
2524: FROM pji_time_cal_period_v
2525: WHERE name = l_period_name
2526: AND calendar_id = x_calendar_id;
2527: ELSE
2528: SELECT name

Line 2530: FROM pji_time_cal_period_v

2526: AND calendar_id = x_calendar_id;
2527: ELSE
2528: SELECT name
2529: INTO l_period_name
2530: FROM pji_time_cal_period_v
2531: WHERE l_report_date BETWEEN start_date AND end_date
2532: AND calendar_id = x_calendar_id;
2533: END IF;
2534: END IF;

Line 5529: FROM pji_time_cal_period_v

5525: WHERE TO_DATE(p_as_of_date, 'j') BETWEEN start_date AND end_date;
5526: ELSE
5527: SELECT name,TO_CHAR(start_date,'j')
5528: INTO x_period_name, x_report_date_julian
5529: FROM pji_time_cal_period_v
5530: WHERE calendar_id = x_calendar_id
5531: AND TO_DATE(p_as_of_date,'j') BETWEEN start_date AND end_date;
5532: END IF;
5533: