APPS.ASG_DOWNLOAD dependencies on JTF_RS_RESOURCE_EXTNS

Line 2485: select user_name from jtf_rs_resource_extns

2481: is
2482: select user_id from fnd_user where user_name = p_user_name;
2483: cursor c_chk_jtf_resource(p_res_id number)
2484: is
2485: select user_name from jtf_rs_resource_extns
2486: where resource_id = p_res_id
2487: and ( trunc(END_DATE_ACTIVE) is null
2488: or trunc(END_DATE_ACTIVE) > trunc(sysdate) );
2489: begin

Line 2539: ' record exists in jtf_rs_resource_extns ';

2535: if(l_user_name is null) then
2536: /* Check if a record exists in jtf_rs_res* table with the
2537: same resource_id as asg_user.resource_id*/
2538: l_err_msg := 'For the resource ID '||l_asg_user_rec.resource_id||' no'||
2539: ' record exists in jtf_rs_resource_extns ';
2540: log(l_err_msg);
2541: update asg_user
2542: set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg
2543: where user_name = l_asg_user_rec.user_name;