DBA Data[Home] [Help]

APPS.GMS_BUDGET_PUB dependencies on FND_PROFILE_OPTION_VALUES

Line 3793: fnd_profile_option_values v

3789:
3790: SELECT profile_option_value
3791: INTO l_user_profile_value1
3792: FROM fnd_profile_options p,
3793: fnd_profile_option_values v
3794: WHERE p.profile_option_name = 'PA_SUPER_PROJECT'
3795: AND v.profile_option_id = p.profile_option_id
3796: AND v.level_id = 10004
3797: AND v.level_value = fnd_global.user_id;

Line 3820: fnd_profile_option_values v

3816:
3817: SELECT profile_option_value
3818: INTO l_user_profile_value2
3819: FROM fnd_profile_options p,
3820: fnd_profile_option_values v
3821: WHERE p.profile_option_name = 'PA_SUPER_PROJECT_VIEW'
3822: AND v.profile_option_id = p.profile_option_id
3823: AND v.level_id = 10004
3824: AND v.level_value = fnd_global.user_id;