APPS.PJI_REP_UTIL dependencies on PJI_TIME_ENT_PERIOD_V

Line 2235: FROM pji_time_ent_period_v

2231: IF p_calendar_id = -1 THEN
2232:
2233: SELECT COUNT(*)
2234: INTO l_rec_count
2235: FROM pji_time_ent_period_v
2236: WHERE start_date >= l_start_date
2237: AND end_date <= l_end_date;
2238:
2239: IF l_rec_count > 12 THEN

Line 2248: x_slice_name := 'PJI_TIME_ENT_PERIOD_V';

2244: WHERE start_date >= l_start_date
2245: AND end_date <= l_end_date;
2246:
2247: IF l_rec_count <= 1 THEN
2248: x_slice_name := 'PJI_TIME_ENT_PERIOD_V';
2249: ELSIF l_rec_count > 12 THEN
2250:
2251: SELECT COUNT(*)
2252: INTO l_rec_count

Line 2266: x_slice_name := 'PJI_TIME_ENT_PERIOD_V';

2262: ELSE
2263: x_slice_name := 'PJI_TIME_ENT_QTR_V';
2264: END IF;
2265: ELSE
2266: x_slice_name := 'PJI_TIME_ENT_PERIOD_V';
2267: END IF;
2268: ELSE
2269:
2270: SELECT COUNT(*)

Line 2839: FROM pji_time_ent_period_v

2835: IF p_calendar_type = 'E' THEN
2836: IF l_active_rep IN ('CURRENT','PRIOR') THEN
2837: SELECT start_date
2838: INTO l_report_date
2839: FROM pji_time_ent_period_v
2840: WHERE TRUNC(SYSDATE) BETWEEN start_date AND end_date;
2841: END IF;
2842:
2843: IF l_active_rep = 'PRIOR' THEN

Line 2846: FROM pji_time_ent_period_v

2842:
2843: IF l_active_rep = 'PRIOR' THEN
2844: SELECT MAX(start_date)
2845: INTO l_report_date
2846: FROM pji_time_ent_period_v
2847: WHERE end_date 2848: END IF;
2849:
2850: IF l_active_rep = 'SPECIFIC' THEN

Line 2855: FROM pji_time_ent_period_v

2851: l_period_name := l_specific_period;
2852:
2853: SELECT start_date
2854: INTO l_report_date
2855: FROM pji_time_ent_period_v
2856: WHERE name = l_period_name;
2857: ELSE
2858: SELECT name
2859: INTO l_period_name

Line 2860: FROM pji_time_ent_period_v

2856: WHERE name = l_period_name;
2857: ELSE
2858: SELECT name
2859: INTO l_period_name
2860: FROM pji_time_ent_period_v
2861: WHERE l_report_date BETWEEN start_date AND end_date;
2862: END IF;
2863: ELSE
2864: IF l_active_rep ='FIRST_OPEN' THEN

Line 6008: FROM pji_time_ent_period_v

6004:
6005: IF x_calendar_type = 'E' THEN
6006: SELECT name,TO_CHAR(start_date,'j')
6007: INTO x_period_name, x_report_date_julian
6008: FROM pji_time_ent_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