2375: and rownum =1 ;
2376:
2377: SELECT responsibility_id
2378: INTO l_resp_id
2379: FROM FND_responsibility_vl
2380: where application_Id = l_application_id
2381: and rownum =1 ;
2382:
2383: exception when no_data_found then
2389: and rownum = 1;
2390:
2391: SELECT responsibility_id
2392: INTO l_resp_id
2393: FROM FND_responsibility_vl
2394: where application_Id = l_application_id
2395: and rownum =1 ;
2396: end;
2397: