DBA Data[Home] [Help]

APPS.QP_DEALS_UTIL dependencies on FND_USER_VIEW

Line 98: from fnd_user_view

94: x_is_curr_inst_deal_inst := 'N';
95: end if;
96:
97: select user_name into l_usr_name
98: from fnd_user_view
99: where user_id = fnd_global.user_id;
100:
101: debug_log(p_origin,
102: 'Checking if user context is available in deal instance..');

Line 113: l_sql := 'select user_id from fnd_user_view' || l_db_link

109:
110: if nvl(l_usr_id , -1) = -1 then
111: debug_log(p_origin, 'Setting user context in deal instance for user '|| l_usr_name);
112: begin
113: l_sql := 'select user_id from fnd_user_view' || l_db_link
114: || ' where user_name = :1' ;
115: execute immediate l_sql into l_usr_id using l_usr_name ;
116:
117: l_sql := 'select application_id, responsibility_id from fnd_responsibility' || l_db_link;