DBA Data[Home] [Help]

APPS.GMS_SUMMARIZE_BUDGETS dependencies on FND_PROFILE_OPTIONS

Line 925: FROM fnd_profile_options p,

921:
922: BEGIN
923: SELECT profile_option_value
924: INTO l_user_profile_value1
925: FROM fnd_profile_options p,
926: fnd_profile_option_values v
927: WHERE p.profile_option_name = 'PA_SUPER_PROJECT'
928: AND v.profile_option_id = p.profile_option_id
929: AND v.level_id = 10004

Line 950: FROM fnd_profile_options p,

946: if ((l_user_profile_value2 = 'N') OR (l_user_profile_value2 is null)) then
947: BEGIN
948: SELECT profile_option_value
949: INTO l_user_profile_value2
950: FROM fnd_profile_options p,
951: fnd_profile_option_values v
952: WHERE p.profile_option_name = 'PA_SUPER_PROJECT_VIEW'
953: AND v.profile_option_id = p.profile_option_id
954: AND v.level_id = 10004