DBA Data[Home] [Help]

APPS.MSC_GET_PROFILE dependencies on FND_PROFILE_OPTION_VALUES

Line 48: from fnd_profile_option_values

44: -- and user levels (10001/10002/10004)
45: --
46: cursor value_uas(pid number, aid number, lid number, lval number) is
47: select profile_option_value
48: from fnd_profile_option_values
49: where profile_option_id = pid
50: and application_id = aid
51: and level_id = lid
52: and level_value = lval;

Line 60: from fnd_profile_option_values

56: -- level (10003)
57: --
58: cursor value_resp(pid number, aid number, lval number, laid number) is
59: select profile_option_value
60: from fnd_profile_option_values
61: where profile_option_id = pid
62: and application_id = aid
63: and level_id = 10003
64: and level_value = lval