DBA Data[Home] [Help]

APPS.MTH_UTIL_PKG dependencies on MTH_HOUR_D

Line 2885: LEAD( TO_TIME ,i) OVER(ORDER BY FROM_TIME) LEAD_TO_DATE FROM MTH_HOUR_D)

2881: SELECT LEAD_HOUR,LEAD_FROM_DATE,LEAD_TO_DATE, LEAST(p_to_date, LEAD_TO_DATE)
2882: INTO v_next_hour_fk_key, v_next_hour_from_time, v_next_hour_to_time, v_least_to_date
2883: FROM(
2884: SELECT HOUR_PK,LEAD( HOUR_PK_KEY ,i) OVER(ORDER BY FROM_TIME ) LEAD_HOUR, LEAD( FROM_TIME,i) OVER(ORDER BY FROM_TIME ) LEAD_FROM_DATE,
2885: LEAD( TO_TIME ,i) OVER(ORDER BY FROM_TIME) LEAD_TO_DATE FROM MTH_HOUR_D)
2886: WHERE HOUR_PK = p_hour_fk;
2887:
2888: IF (v_next_hour_from_time <= v_least_to_date)
2889: THEN