APPS.EDW_SEC_REF SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 39

select application_id into x_appl_id from fnd_application_vl
where application_short_name =  x_app_name;

Line: 42

select responsibility_id into x_resp_id from fnd_responsibility_vl
where responsibility_key = x_resp_key
and application_id = x_appl_id;

Line: 46

select distinct fact_id into x_fact_id from edw_sec_fact_info_t
where fact_name = fact_physical_name;

Line: 49

select dim_id into x_dim_id from edw_sec_fact_info_t
where fact_name = fact_physical_name
and fk_col_name = fk_column_physical_name;

Line: 53

select dim_name into x_dim_name from edw_sec_dim_info_t
where dim_id = x_dim_id;

Line: 59

select count(*) into x_rec_count from edw_sec_ref_info_t
where appl_id = x_appl_id
and resp_id = x_resp_id
and fact_id = x_fact_id
and fk_col_name = fk_column_physical_name;

Line: 70

Insert into edw_sec_ref_info_t
	(appl_id,
	resp_id,
	fact_id,
	fact_name,
	dim_id,
	dim_name,
	fk_col_name)
values
	(x_appl_id,
	x_resp_id,
	x_fact_id,
	fact_physical_name,
	x_dim_id,
	x_dim_name,
	fk_column_physical_name);

Line: 152

select application_id into x_appl_id from fnd_application_vl
where application_short_name =  x_app_name;

Line: 155

select responsibility_id into x_resp_id from fnd_responsibility_vl
where responsibility_key = x_resp_key
and application_id = x_appl_id;

Line: 159

select distinct fact_id into x_fact_id from edw_sec_fact_info_t
where fact_name = fact_physical_name;

Line: 162

select dim_id into x_dim_id from edw_sec_fact_info_t
where fact_name = fact_physical_name
and fk_col_name = fk_column_physical_name;

Line: 168

Delete from edw_sec_ref_info_t
where appl_id = x_appl_id
and resp_id = x_resp_id
and fact_id = x_fact_id
and fk_col_name = fk_column_physical_name;