19: l_application_id number;
20:
21: cursor resp_exists(l_resp_name varchar2) IS
22: select responsibility_id
23: from fnd_responsibility_vl
24: where application_id = l_application_id
25: and responsibility_name = l_resp_name;
26:
27: BEGIN
57: if l_resp_id is null then
58:
59: SELECT responsibility_id
60: INTO l_resp_id
61: FROM FND_responsibility_vl
62: where application_Id = l_application_id
63: and rownum =1 ;
64:
65: end if;
73: and rownum = 1;
74:
75: SELECT responsibility_id
76: INTO l_resp_id
77: FROM FND_responsibility_vl
78: where application_Id = l_application_id
79: and rownum =1 ;
80: end;
81:
210: and rownum = 1;
211:
212: SELECT responsibility_id
213: INTO l_resp_id
214: FROM FND_responsibility_vl
215: where application_Id = l_application_id
216: and rownum = 1;
217:
218: select operating_unit
315: and rownum = 1;
316:
317: SELECT responsibility_id
318: INTO l_resp_id
319: FROM FND_responsibility_vl
320: where application_Id = l_application_id
321: and rownum = 1;
322:
323: select operating_unit
383: where application_short_name = p_appl_name;
384:
385: select responsibility_id
386: into l_resp_id
387: from fnd_responsibility_vl
388: where responsibility_name = p_resp_name
389: and application_Id = l_appl_id;
390:
391: exception