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
47: where fact_name = fact_physical_name;
48:
49: select dim_id into x_dim_id from edw_sec_fact_info_t
50: where fact_name = fact_physical_name
45:
46: select distinct fact_id into x_fact_id from edw_sec_fact_info_t
47: where fact_name = fact_physical_name;
48:
49: select dim_id into x_dim_id from edw_sec_fact_info_t
50: where fact_name = fact_physical_name
51: and fk_col_name = fk_column_physical_name;
52:
53: select dim_name into x_dim_name from edw_sec_dim_info_t
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
160: where fact_name = fact_physical_name;
161:
162: select dim_id into x_dim_id from edw_sec_fact_info_t
163: where fact_name = fact_physical_name
158:
159: select distinct fact_id into x_fact_id from edw_sec_fact_info_t
160: where fact_name = fact_physical_name;
161:
162: select dim_id into x_dim_id from edw_sec_fact_info_t
163: where fact_name = fact_physical_name
164: and fk_col_name = fk_column_physical_name;
165:
166: -- Delete Row