APPS.BIM_POPDATES_PKG dependencies on FND_PROFILE

Line 11: WHERE period_set_name = fnd_profile.value('AMS_CAMPAIGN_DEFAULT_CALENDER');

7: PROCEDURE POP_INTL_DATES(p_input_date DATE) IS
8: CURSOR min_gl_date IS
9: SELECT TRUNC(min(start_date))
10: FROM gl_periods
11: WHERE period_set_name = fnd_profile.value('AMS_CAMPAIGN_DEFAULT_CALENDER');
12:
13: CURSOR max_gl_date IS
14: SELECT TRUNC(max(end_date))
15: FROM gl_periods

Line 16: WHERE period_set_name = fnd_profile.value('AMS_CAMPAIGN_DEFAULT_CALENDER');

12:
13: CURSOR max_gl_date IS
14: SELECT TRUNC(max(end_date))
15: FROM gl_periods
16: WHERE period_set_name = fnd_profile.value('AMS_CAMPAIGN_DEFAULT_CALENDER');
17:
18: cursor min_object_date (p_date DATE) is
19: select trunc(min(de)) from (
20: select min(bu1.approval_date) de