APPS.MRP_REL_WF dependencies on FND_APPLICATION_VL

Line 36: FROM FND_APPLICATION_VL

32: begin
33:
34: SELECT APPLICATION_ID
35: INTO l_application_id
36: FROM FND_APPLICATION_VL
37: WHERE APPLICATION_SHORT_NAME = 'MSC'
38: and rownum = 1;
39:
40: -- first try to see if current destination responsibility exists in source

Line 71: FROM FND_APPLICATION_VL

67: exception when no_data_found then
68:
69: SELECT APPLICATION_ID
70: INTO l_application_id
71: FROM FND_APPLICATION_VL
72: WHERE APPLICATION_SHORT_NAME = 'MRP'
73: and rownum = 1;
74:
75: SELECT responsibility_id

Line 208: FROM FND_APPLICATION_VL

204: where user_name= p_user_name; -- here I can pass any userid
205:
206: SELECT APPLICATION_ID
207: INTO l_application_id
208: FROM FND_APPLICATION_VL
209: WHERE APPLICATION_SHORT_NAME ='PJM'
210: and rownum = 1;
211:
212: SELECT responsibility_id

Line 313: FROM FND_APPLICATION_VL

309: where user_name= p_user_name; -- here I can pass any userid
310:
311: SELECT APPLICATION_ID
312: INTO l_application_id
313: FROM FND_APPLICATION_VL
314: WHERE APPLICATION_SHORT_NAME ='PJM'
315: and rownum = 1;
316:
317: SELECT responsibility_id

Line 382: from fnd_application_vl

378: where user_name = p_user_name;
379:
380: select application_id
381: into l_appl_id
382: from fnd_application_vl
383: where application_short_name = p_appl_name;
384:
385: select responsibility_id
386: into l_resp_id