APPS.PA_REPORT_UTIL dependencies on FND_PROFILE_OPTIONS_TL

Line 200: FROM fnd_profile_options_tl

196:
197: l_global_week_start_day := FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY');
198:
199: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1
200: FROM fnd_profile_options_tl
201: WHERE profile_option_name='PA_ORG_UTIL_DEF_CALC_METHOD'
202: AND language=userenv('LANG');
203:
204: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2

Line 205: FROM fnd_profile_options_tl

201: WHERE profile_option_name='PA_ORG_UTIL_DEF_CALC_METHOD'
202: AND language=userenv('LANG');
203:
204: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2
205: FROM fnd_profile_options_tl
206: WHERE profile_option_name='PA_ORG_UTIL_DEF_PERIOD_TYPE'
207: AND language=userenv('LANG');
208:
209: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name3

Line 210: FROM fnd_profile_options_tl

206: WHERE profile_option_name='PA_ORG_UTIL_DEF_PERIOD_TYPE'
207: AND language=userenv('LANG');
208:
209: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name3
210: FROM fnd_profile_options_tl
211: WHERE profile_option_name='PA_GLOBAL_WEEK_START_DAY'
212: AND language=userenv('LANG');
213:
214:

Line 1164: FROM fnd_profile_options_tl

1160: l_def_show_percentages_by := FND_PROFILE.VALUE('PA_RES_UTIL_DEF_CALC_METHOD');
1161: l_global_week_start_day := FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY');
1162:
1163: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1
1164: FROM fnd_profile_options_tl
1165: WHERE profile_option_name='PA_RES_UTIL_DEF_CALC_METHOD'
1166: AND language=userenv('LANG');
1167:
1168: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2

Line 1169: FROM fnd_profile_options_tl

1165: WHERE profile_option_name='PA_RES_UTIL_DEF_CALC_METHOD'
1166: AND language=userenv('LANG');
1167:
1168: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2
1169: FROM fnd_profile_options_tl
1170: WHERE profile_option_name='PA_RES_UTIL_DEF_PERIOD_TYPE'
1171: AND language=userenv('LANG');
1172:
1173: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name3

Line 1174: FROM fnd_profile_options_tl

1170: WHERE profile_option_name='PA_RES_UTIL_DEF_PERIOD_TYPE'
1171: AND language=userenv('LANG');
1172:
1173: SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name3
1174: FROM fnd_profile_options_tl
1175: WHERE profile_option_name='PA_GLOBAL_WEEK_START_DAY'
1176: AND language=userenv('LANG');
1177:
1178: