APPS.CSM_HTML5_PKG dependencies on CSM_QUERY_INSTANCES_ACC

Line 1985: delete from csm_query_instances_acc

1981: IF c_purge_days%FOUND AND l_days IS NOT NULL AND l_days>0 THEN
1982: delete from csm_html5_ajax_info where creation_date < (sysdate-l_days);
1983: delete from csm_html5_sync_info where start_date < (sysdate-l_days);
1984: delete from csm_html5_sync_details a where not exists(select 1 from csm_html5_sync_info b where a.session_id=b.session_id);
1985: delete from csm_query_instances_acc
1986: where creation_date < (sysdate-l_days)
1987: and query_id between 1 and 99
1988: and instance_id not in (select to_number(prf_value) from csm_html5_clients_info WHERE PRF_NAME='SCHEMA_REUSE' OR PRF_NAME like 'REUSABLE%' OR PRF_NAME LIKE 'USER_CREAT%')
1989: and not exists (select 1 from csm_html5_sync_info where instance_id=q_instance_id);

Line 1990: delete from csm_query_results_acc where instance_id not in ( select instance_id from csm_query_instances_acc where query_id between 1 and 99 );

1986: where creation_date < (sysdate-l_days)
1987: and query_id between 1 and 99
1988: and instance_id not in (select to_number(prf_value) from csm_html5_clients_info WHERE PRF_NAME='SCHEMA_REUSE' OR PRF_NAME like 'REUSABLE%' OR PRF_NAME LIKE 'USER_CREAT%')
1989: and not exists (select 1 from csm_html5_sync_info where instance_id=q_instance_id);
1990: delete from csm_query_results_acc where instance_id not in ( select instance_id from csm_query_instances_acc where query_id between 1 and 99 );
1991: END IF;
1992: CLOSE c_purge_days;
1993:
1994: