APPS.BIM_CAMP_COLLECTION dependencies on FND_PROFILE

Line 13: fnd_profile.VALUE('AMS_CAMPAIGN_DEFAULT_CALENDER')

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)
15: AND TRUNC(start_date) <= SYSDATE
16: AND ADJUSTMENT_PERIOD_FLAG ='N';
17: CURSOR c_quarter(l_date IN DATE)

Line 24: fnd_profile.VALUE('AMS_CAMPAIGN_DEFAULT_CALENDER')

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)
26: AND TRUNC(start_date) <= SYSDATE;
27: CURSOR c_year(l_date IN DATE)
28: IS

Line 34: fnd_profile.VALUE('AMS_CAMPAIGN_DEFAULT_CALENDER')

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
36: OR TRUNC(l_date) < start_date
37: )
38: AND TRUNC(start_date) <= SYSDATE;