APPS.EDW_SEC_REF dependencies on FND_APPLICATION_VL

Line 39: select application_id into x_appl_id from fnd_application_vl

35: x_app_name := application_short_name;
36: x_resp_key :=responsibility_key;
37:
38:
39: select application_id into x_appl_id from fnd_application_vl
40: where application_short_name = x_app_name;
41:
42: select responsibility_id into x_resp_id from fnd_responsibility_vl
43: where responsibility_key = x_resp_key

Line 152: select application_id into x_appl_id from fnd_application_vl

148: x_app_name := application_short_name;
149: x_resp_key :=responsibility_key;
150:
151:
152: select application_id into x_appl_id from fnd_application_vl
153: where application_short_name = x_app_name;
154:
155: select responsibility_id into x_resp_id from fnd_responsibility_vl
156: where responsibility_key = x_resp_key