DBA Data[Home] [Help]

APPS.HR_SEC3_UPDATE dependencies on FND_PROFILE_OPTION_VALUES

Line 125: from FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V

121: option_value out nocopy varchar2 ,
122: defined out nocopy boolean ) is
123: cursor c1 is
124: select V.PROFILE_OPTION_VALUE
125: from FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V
126: where O.PROFILE_OPTION_NAME = option_name
127: and V.LEVEL_ID = 10003 and V.LEVEL_VALUE = to_char(resp_id)
128: and V.LEVEL_VALUE_APPLICATION_ID = to_char(appl_id)
129: and O.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID