APPS.JTF_TTY_GEO_WEBADI_INT_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 295: select resource_id into l_rsc_id from jtf_rs_resource_extns

291:
292: user_id := to_number(p_userid);
293:
294: begin
295: select resource_id into l_rsc_id from jtf_rs_resource_extns
296: where user_id = p_userid;
297:
298: exception
299: when no_data_found then

Line 558: select resource_id into rsc_id from jtf_rs_resource_extns

554: RETURN;
555: END IF;
556:
557: --insert into tmp values('glb userid',l_user_id); commit;
558: select resource_id into rsc_id from jtf_rs_resource_extns
559: where user_id = l_user_id;
560:
561: --Does this Postal Code belong to the current user, i.e., does the user have permission
562: --to assign this postal code to the territories he created?