eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_GENERAL_UTILS dependencies on CN_PERIODS

Line 101: FROM cn_periods

97: RETURN NUMBER IS X_period_id NUMBER;
98: BEGIN
99: SELECT period_id
100: INTO X_period_id
101: FROM cn_periods
102: WHERE X_period_date BETWEEN trunc(start_date)
103: AND trunc(end_date)
104: ;
105: RETURN X_period_id;

Line 145: FROM cn_periods p

141: ,x_period_status
142: ,x_period_name
143: ,x_start_date
144: ,x_end_date
145: FROM cn_periods p
146: WHERE ( x_period_date IS NULL
147: OR x_period_date BETWEEN trunc(p.start_date)
148: AND trunc(p.end_date) )
149: AND ( x_period_name IS NULL

Line 177: FROM cn_periods

173: RETURN VARCHAR2 IS X_period_name VARCHAR2(30);
174: BEGIN
175: SELECT period_name
176: INTO X_period_name
177: FROM cn_periods
178: WHERE period_id = X_period_id
179: ;
180: RETURN X_period_name;
181: