DBA Data[Home] [Help]

APPS.PJI_UTILS dependencies on PJI_TIME_ENT_PERIOD_V

Line 1448: FROM pji_time_ent_period_v

1444: IF p_calendar_type = 'E' THEN
1445: IF p_active_rep IN ('CURRENT','PRIOR') THEN
1446: SELECT start_date
1447: INTO l_report_date
1448: FROM pji_time_ent_period_v
1449: WHERE TRUNC(SYSDATE) BETWEEN start_date AND end_date;
1450: END IF;
1451:
1452: IF p_active_rep = 'PRIOR' THEN

Line 1455: FROM pji_time_ent_period_v

1451:
1452: IF p_active_rep = 'PRIOR' THEN
1453: SELECT MAX(start_date)
1454: INTO l_report_date
1455: FROM pji_time_ent_period_v
1456: WHERE end_date 1457: END IF;
1458: IF p_active_rep = 'SPECIFIC' THEN
1459: l_period_name := l_specific_ent_period;

Line 1463: FROM pji_time_ent_period_v

1459: l_period_name := l_specific_ent_period;
1460: ELSE
1461: SELECT name
1462: INTO l_period_name
1463: FROM pji_time_ent_period_v
1464: WHERE l_report_date BETWEEN start_date AND end_date;
1465: END IF;
1466:
1467: ELSE