APPS.IBW_PURGE_PVT dependencies on IBW_PAGE_INSTANCES

Line 17: -- IBW_SITE_VISITS, IBW_VISITORS, IBW_PAGE_INSTANCES.

13: -- Private API for purging transaction data
14: --
15: -- NOTES
16: -- Administrator uses this program to purge the transaction data. The tables which will be purged are IBW_PAGE_VIEWS,
17: -- IBW_SITE_VISITS, IBW_VISITORS, IBW_PAGE_INSTANCES.
18:
19: -- HISTORY
20: -- 05/10/2005 VEKANCHA Created
21:

Line 93: /** purge ibw_page_instances */

89: WHERE 0 = (SELECT COUNT(visitor_id)
90: FROM ibw_site_visits visit
91: WHERE visit.visitor_id=visitors.visitor_id);
92:
93: /** purge ibw_page_instances */
94: DELETE FROM ibw_page_instances pi
95: WHERE 0 = (SELECT COUNT(page_instance_id)
96: FROM ibw_page_views pv
97: WHERE pv.page_instance_id=pi.page_instance_id);

Line 94: DELETE FROM ibw_page_instances pi

90: FROM ibw_site_visits visit
91: WHERE visit.visitor_id=visitors.visitor_id);
92:
93: /** purge ibw_page_instances */
94: DELETE FROM ibw_page_instances pi
95: WHERE 0 = (SELECT COUNT(page_instance_id)
96: FROM ibw_page_views pv
97: WHERE pv.page_instance_id=pi.page_instance_id);
98: