DBA Data[Home] [Help]

APPS.PJI_TIME_C dependencies on FII_TIME_CAL_NAME

Line 1595: FROM fii_time_cal_name

1591: ELSIF p_period_set_name IS NOT NULL AND p_period_set_name IS NOT NULL THEN
1592: BEGIN
1593: SELECT calendar_id
1594: INTO l_calendar_id
1595: FROM fii_time_cal_name
1596: WHERE period_set_name = p_period_set_name
1597: AND period_type = p_period_type;
1598: EXCEPTION
1599: WHEN NO_DATA_FOUND THEN

Line 1618: FROM fii_time_cal_name cal

1614: , l_period_type_tbl
1615: , l_earliest_start_dates_tbl
1616: , l_latest_end_dates_tbl
1617: , l_cal_info_exists_tbl
1618: FROM fii_time_cal_name cal
1619: , PJI_TIME_CAL_EXTR_INFO info
1620: WHERE 1=1
1621: AND cal.calendar_id = info.calendar_id (+)
1622: AND cal.calendar_id = NVL(l_calendar_id,cal.calendar_id)