APPS.PJI_UTILS dependencies on PJI_TIME_CAL_PERIOD_V

Line 1370: pji_time_cal_period_v TIM

1366: IF p_active_rep ='FIRST_OPEN' THEN
1367: SELECT MIN(TIM.start_date) first_open
1368: INTO l_report_date
1369: FROM
1370: pji_time_cal_period_v TIM
1371: , gl_period_statuses glps
1372: , pa_implementations_all paimp
1373: WHERE 1=1
1374: AND TIM.calendar_id = l_calendar_id

Line 1384: pji_time_cal_period_v TIM

1380: ELSIF p_active_rep = 'LAST_OPEN' THEN
1381: SELECT MAX(TIM.start_date) last_open
1382: INTO l_report_date
1383: FROM
1384: pji_time_cal_period_v TIM
1385: , gl_period_statuses glps
1386: , pa_implementations_all paimp
1387: WHERE 1=1
1388: AND TIM.calendar_id = l_calendar_id

Line 1398: pji_time_cal_period_v TIM

1394: ELSIF p_active_rep = 'LAST_CLOSED' THEN
1395: SELECT MAX(TIM.start_date) last_closed
1396: INTO l_report_date
1397: FROM
1398: pji_time_cal_period_v TIM
1399: , gl_period_statuses glps
1400: , pa_implementations_all paimp
1401: WHERE 1=1
1402: AND TIM.calendar_id = l_calendar_id

Line 1411: FROM pji_time_cal_period_v

1407: AND closing_status = 'C';
1408: ELSIF p_active_rep IN ('CURRENT','PRIOR') THEN
1409: SELECT start_date
1410: INTO l_report_date
1411: FROM pji_time_cal_period_v
1412: WHERE TRUNC(SYSDATE) BETWEEN start_date
1413: AND end_date
1414: AND calendar_id = l_calendar_id;
1415: END IF;

Line 1420: FROM pji_time_cal_period_v

1416:
1417: IF p_active_rep = 'PRIOR' THEN
1418: SELECT MAX(start_date)
1419: INTO l_report_date
1420: FROM pji_time_cal_period_v
1421: WHERE end_date < l_report_date
1422: AND calendar_id = l_calendar_id;
1423: END IF;
1424:

Line 1430: FROM pji_time_cal_period_v

1426: l_period_name := l_specific_period;
1427: ELSE
1428: SELECT name
1429: INTO l_period_name
1430: FROM pji_time_cal_period_v
1431: WHERE l_report_date BETWEEN start_date AND end_date
1432: AND calendar_id = l_calendar_id;
1433: END IF;
1434: