APPS.CN_PURGE_PKG dependencies on CN_PERIODS

Line 32: FROM cn_periods

28: l_end_date DATE;
29: BEGIN
30: SELECT period_id, start_date
31: INTO l_start_period_id, l_start_date
32: FROM cn_periods
33: WHERE period_name like x_start_period;
34:
35: SELECT period_id, end_date
36: INTO l_end_period_id, l_end_date

Line 37: FROM cn_periods

33: WHERE period_name like x_start_period;
34:
35: SELECT period_id, end_date
36: INTO l_end_period_id, l_end_date
37: FROM cn_periods
38: WHERE period_name like x_end_period;
39:
40: -- Delete process batches from CN_PROCESS_BATCHES with status_code = 'VOID'
41: DELETE FROM CN_PROCESS_BATCHES WHERE status_code = 'VOID';