APPS.EDW_SEC_REF dependencies on FND_RESPONSIBILITY_VL

Line 42: select responsibility_id into x_resp_id from fnd_responsibility_vl

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
44: and application_id = x_appl_id;
45:
46: select distinct fact_id into x_fact_id from edw_sec_fact_info_t

Line 155: select responsibility_id into x_resp_id from fnd_responsibility_vl

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
157: and application_id = x_appl_id;
158:
159: select distinct fact_id into x_fact_id from edw_sec_fact_info_t