APPS.JTF_TTY_GEO_WEBADI_INT_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 287: select resource_id into l_rsc_id from jtf_rs_resource_extns

283:
284: user_id := to_number(p_userid);
285:
286: begin
287: select resource_id into l_rsc_id from jtf_rs_resource_extns
288: where user_id = p_userid;
289:
290: exception
291: when no_data_found then

Line 538: select resource_id into rsc_id from jtf_rs_resource_extns

534:
535:
536:
537: --insert into tmp values('glb userid',l_user_id); commit;
538: select resource_id into rsc_id from jtf_rs_resource_extns
539: where user_id = l_user_id;
540:
541: --Does this Postal Code belong to the current user, i.e., does the user have permission
542: --to assign this postal code to the territories he created?