APPS.PJI_REP_UTIL dependencies on PJI_TIME_ENT_PERIOD

Line 1845: FROM pji_time_ent_period_v

1841: IF p_calendar_id = -1 THEN
1842:
1843: SELECT COUNT(*)
1844: INTO l_rec_count
1845: FROM pji_time_ent_period_v
1846: WHERE start_date >= l_start_date
1847: AND end_date <= l_end_date;
1848:
1849: IF l_rec_count > 12 THEN

Line 1858: x_slice_name := 'PJI_TIME_ENT_PERIOD_V';

1854: WHERE start_date >= l_start_date
1855: AND end_date <= l_end_date;
1856:
1857: IF l_rec_count <= 1 THEN
1858: x_slice_name := 'PJI_TIME_ENT_PERIOD_V';
1859: ELSIF l_rec_count > 12 THEN
1860:
1861: SELECT COUNT(*)
1862: INTO l_rec_count

Line 1876: x_slice_name := 'PJI_TIME_ENT_PERIOD_V';

1872: ELSE
1873: x_slice_name := 'PJI_TIME_ENT_QTR_V';
1874: END IF;
1875: ELSE
1876: x_slice_name := 'PJI_TIME_ENT_PERIOD_V';
1877: END IF;
1878: ELSE
1879:
1880: SELECT COUNT(*)

Line 2438: FROM pji_time_ent_period_v

2434: IF p_calendar_type = 'E' THEN
2435: IF l_active_rep IN ('CURRENT','PRIOR') THEN
2436: SELECT start_date
2437: INTO l_report_date
2438: FROM pji_time_ent_period_v
2439: WHERE TRUNC(SYSDATE) BETWEEN start_date AND end_date;
2440: END IF;
2441:
2442: IF l_active_rep = 'PRIOR' THEN

Line 2445: FROM pji_time_ent_period_v

2441:
2442: IF l_active_rep = 'PRIOR' THEN
2443: SELECT MAX(start_date)
2444: INTO l_report_date
2445: FROM pji_time_ent_period_v
2446: WHERE end_date 2447: END IF;
2448:
2449: IF l_active_rep = 'SPECIFIC' THEN

Line 2454: FROM pji_time_ent_period_v

2450: l_period_name := l_specific_period;
2451:
2452: SELECT start_date
2453: INTO l_report_date
2454: FROM pji_time_ent_period_v
2455: WHERE name = l_period_name;
2456: ELSE
2457: SELECT name
2458: INTO l_period_name

Line 2459: FROM pji_time_ent_period_v

2455: WHERE name = l_period_name;
2456: ELSE
2457: SELECT name
2458: INTO l_period_name
2459: FROM pji_time_ent_period_v
2460: WHERE l_report_date BETWEEN start_date AND end_date;
2461: END IF;
2462: ELSE
2463: IF l_active_rep ='FIRST_OPEN' THEN

Line 3369: FROM pji_time_ent_period

3365:
3366: IF p_calendar_type = 'E' THEN
3367: SELECT end_date
3368: INTO l_report_date
3369: FROM pji_time_ent_period
3370: WHERE TO_DATE(p_report_date_julian,'j') BETWEEN start_date AND end_date;
3371: ELSIF p_calendar_type = 'G' OR p_calendar_type = 'P' THEN
3372: SELECT end_date
3373: INTO l_report_date

Line 5524: FROM pji_time_ent_period_v

5520:
5521: IF x_calendar_type = 'E' THEN
5522: SELECT name,TO_CHAR(start_date,'j')
5523: INTO x_period_name, x_report_date_julian
5524: FROM pji_time_ent_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