DBA Data[Home] [Help]

APPS.IEM_UTILITY_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 166: select user_id into l_user_id from JTF_RS_RESOURCE_EXTNS

162: begin
163: --add if condition for changing CherrPick view in UWQ,12.1.2 project
164: if p_resource_id>0 then
165: begin
166: select user_id into l_user_id from JTF_RS_RESOURCE_EXTNS
167: where resource_id=p_resource_id;
168: l_client_tz_id :=to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID',l_user_id));
169: l_time_format :=fnd_profile.value_specific('ICX_DATE_FORMAT_MASK',l_user_id);
170: l_format:=l_time_format||' '||'HH24:MI:SS';