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_CAMP_COLLECTION dependencies on GL_PERIODS

Line 10: FROM gl_periods

6: IS
7: CURSOR c_month(l_date IN DATE)
8: IS
9: SELECT start_date
10: FROM gl_periods
11: WHERE period_type = 'Month'
12: AND period_set_name =
13: fnd_profile.VALUE('AMS_CAMPAIGN_DEFAULT_CALENDER')
14: AND TRUNC(start_date) >= TRUNC(l_date)

Line 21: FROM gl_periods

17: CURSOR c_quarter(l_date IN DATE)
18: IS
19: SELECT start_date,
20: period_num
21: FROM gl_periods
22: WHERE period_type = 'Quarter'
23: AND period_set_name =
24: fnd_profile.VALUE('AMS_CAMPAIGN_DEFAULT_CALENDER')
25: AND TRUNC(start_date) >= TRUNC(l_date)

Line 31: FROM gl_periods

27: CURSOR c_year(l_date IN DATE)
28: IS
29: SELECT start_date,
30: period_num
31: FROM gl_periods
32: WHERE period_type = 'Year'
33: AND period_set_name =
34: fnd_profile.VALUE('AMS_CAMPAIGN_DEFAULT_CALENDER')
35: AND ( TRUNC(l_date) BETWEEN start_date AND end_date