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.BIM_PREV_PERIODS_PKG dependencies on GL_PERIODS

Line 42: FROM gl_periods

38: ,quarter_num
39: INTO l_current_start_num
40: ,l_current_start_year
41: ,l_current_start_quarter_num
42: FROM gl_periods
43: WHERE start_date = p_start_date
44: AND period_type = p_period_type
45: AND rownum < 2;
46: EXCEPTION

Line 59: FROM gl_periods

55: INTO l_current_END_num
56: ,l_current_END_year
57:
58: ,l_current_END_quarter_num
59: FROM gl_periods
60: WHERE END_date = p_END_date
61: AND period_type = p_period_type
62: AND rownum < 2;
63: EXCEPTION

Line 136: FROM gl_periods

132:
133: BEGIN
134: SELECT start_date
135: INTO p_prev_start_date
136: FROM gl_periods
137: WHERE period_num = l_prev_start_num
138: AND period_year = l_prev_start_year
139: AND period_type = p_period_type
140: AND rownum < 2;

Line 149: FROM gl_periods

145:
146: BEGIN
147: SELECT END_date
148: INTO p_prev_END_date
149: FROM gl_periods
150: WHERE period_num = l_prev_END_num
151: AND period_year = l_prev_END_year
152: AND period_type = p_period_type
153: AND rownum < 2;