DBA Data[Home] [Help]

APPS.PJI_UTILS dependencies on PJI_TIME_ENT_PERIOD_V

Line 1331: FROM pji_time_ent_period_v

1327: IF p_calendar_type = 'E' THEN
1328: IF p_active_rep IN ('CURRENT','PRIOR') THEN
1329: SELECT start_date
1330: INTO l_report_date
1331: FROM pji_time_ent_period_v
1332: WHERE TRUNC(SYSDATE) BETWEEN start_date AND end_date;
1333: END IF;
1334:
1335: IF p_active_rep = 'PRIOR' THEN

Line 1338: FROM pji_time_ent_period_v

1334:
1335: IF p_active_rep = 'PRIOR' THEN
1336: SELECT MAX(start_date)
1337: INTO l_report_date
1338: FROM pji_time_ent_period_v
1339: WHERE end_date 1340: END IF;
1341: IF p_active_rep = 'SPECIFIC' THEN
1342: l_period_name := l_specific_ent_period;

Line 1346: FROM pji_time_ent_period_v

1342: l_period_name := l_specific_ent_period;
1343: ELSE
1344: SELECT name
1345: INTO l_period_name
1346: FROM pji_time_ent_period_v
1347: WHERE l_report_date BETWEEN start_date AND end_date;
1348: END IF;
1349:
1350: ELSE