APPS.MRP_REL_WF dependencies on FND_RESPONSIBILITY_VL

Line 23: from fnd_responsibility_vl

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

Line 61: FROM FND_responsibility_vl

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;

Line 77: FROM FND_responsibility_vl

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:

Line 214: FROM FND_responsibility_vl

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

Line 319: FROM FND_responsibility_vl

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

Line 387: from fnd_responsibility_vl

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