APPS.PJI_UTILS dependencies on PJI_TIME_CAL_PERIOD_V

Line 1487: pji_time_cal_period_v TIM

1483: IF p_active_rep ='FIRST_OPEN' THEN
1484: SELECT MIN(TIM.start_date) first_open
1485: INTO l_report_date
1486: FROM
1487: pji_time_cal_period_v TIM
1488: , gl_period_statuses glps
1489: , pa_implementations_all paimp
1490: WHERE 1=1
1491: AND TIM.calendar_id = l_calendar_id

Line 1501: pji_time_cal_period_v TIM

1497: ELSIF p_active_rep = 'LAST_OPEN' THEN
1498: SELECT MAX(TIM.start_date) last_open
1499: INTO l_report_date
1500: FROM
1501: pji_time_cal_period_v TIM
1502: , gl_period_statuses glps
1503: , pa_implementations_all paimp
1504: WHERE 1=1
1505: AND TIM.calendar_id = l_calendar_id

Line 1515: pji_time_cal_period_v TIM

1511: ELSIF p_active_rep = 'LAST_CLOSED' THEN
1512: SELECT MAX(TIM.start_date) last_closed
1513: INTO l_report_date
1514: FROM
1515: pji_time_cal_period_v TIM
1516: , gl_period_statuses glps
1517: , pa_implementations_all paimp
1518: WHERE 1=1
1519: AND TIM.calendar_id = l_calendar_id

Line 1528: FROM pji_time_cal_period_v

1524: AND closing_status = 'C';
1525: ELSIF p_active_rep IN ('CURRENT','PRIOR') THEN
1526: SELECT start_date
1527: INTO l_report_date
1528: FROM pji_time_cal_period_v
1529: WHERE TRUNC(SYSDATE) BETWEEN start_date
1530: AND end_date
1531: AND calendar_id = l_calendar_id;
1532: END IF;

Line 1537: FROM pji_time_cal_period_v

1533:
1534: IF p_active_rep = 'PRIOR' THEN
1535: SELECT MAX(start_date)
1536: INTO l_report_date
1537: FROM pji_time_cal_period_v
1538: WHERE end_date < l_report_date
1539: AND calendar_id = l_calendar_id;
1540: END IF;
1541:

Line 1547: FROM pji_time_cal_period_v

1543: l_period_name := l_specific_period;
1544: ELSE
1545: SELECT name
1546: INTO l_period_name
1547: FROM pji_time_cal_period_v
1548: WHERE l_report_date BETWEEN start_date AND end_date
1549: AND calendar_id = l_calendar_id;
1550: END IF;
1551: