APPS.AP_PURGE_PKG dependencies on CHV_HISTORY_CUM_PERIODS

Line 2440: chv_history_cum_periods chcp

2436: into range_inserted
2437: from sys.dual
2438: where exists (select null
2439: from chv_cum_periods ccp,
2440: chv_history_cum_periods chcp
2441: where ccp.cum_period_id = chcp.cum_period_id
2442: and chcp.purge_name = p_purge_name);
2443:
2444: -- 1783982 fbreslin: Compare using :p_catagory rather than p_purge_name

Line 2449: insert into chv_history_cum_periods

2445:
2446: if (p_category = 'SCHEDULES BY CUM PERIODS' AND
2447: NVL(range_inserted,'N') <> 'Y') then
2448: -- summarize_schedules_by_org
2449: insert into chv_history_cum_periods
2450: (cum_period_id,
2451: cum_period_name,
2452: cum_period_start_date,
2453: cum_period_end_date,

Line 6622: delete from chv_history_cum_periods

6618: BEGIN
6619: delete from chv_history_schedules
6620: where purge_name = g_purge_name;
6621:
6622: delete from chv_history_cum_periods
6623: where purge_name = g_purge_name;
6624:
6625: RETURN (TRUE);
6626: