DBA Data[Home] [Help]

APPS.HR_SECURITY_UTILS dependencies on FND_PROFILE_OPTION_VALUES

Line 109: from FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V

105: option_value out varchar2 ,
106: defined out boolean ) is
107: cursor c1 is
108: select V.PROFILE_OPTION_VALUE
109: from FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V
110: where O.PROFILE_OPTION_NAME = option_name
111: and V.LEVEL_ID = 10003 and V.LEVEL_VALUE = to_char(resp_id)
112: and V.LEVEL_VALUE_APPLICATION_ID = to_char(appl_id)
113: and O.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID

Line 136: from FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V

132: option_value out varchar2 ,
133: defined out boolean ) is
134: cursor c1 is
135: select V.PROFILE_OPTION_VALUE
136: from FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V
137: where O.PROFILE_OPTION_NAME = option_name
138: and V.LEVEL_ID = 10002 and V.LEVEL_VALUE = to_char(appl_id)
139: and O.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID
140: and O.APPLICATION_ID = V.APPLICATION_ID ;