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