DBA Data[Home] [Help]

APPS.GMS_WF_PKG dependencies on FND_PROFILE_OPTION_VALUES

Line 1726: fnd_profile_option_values v

1722:
1723: SELECT profile_option_value
1724: INTO l_user_profile_value1
1725: FROM fnd_profile_options p,
1726: fnd_profile_option_values v
1727: WHERE p.profile_option_name = 'PA_SUPER_PROJECT'
1728: AND v.profile_option_id = p.profile_option_id
1729: AND v.level_id = 10004
1730: AND v.level_value = fnd_global.user_id;

Line 1763: fnd_profile_option_values v

1759:
1760: SELECT profile_option_value
1761: INTO l_user_profile_value2
1762: FROM fnd_profile_options p,
1763: fnd_profile_option_values v
1764: WHERE p.profile_option_name = 'PA_SUPER_PROJECT_VIEW'
1765: AND v.profile_option_id = p.profile_option_id
1766: AND v.level_id = 10004
1767: AND v.level_value = fnd_global.user_id;