DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on CHV_HISTORY_CUM_PERIODS

Line 2695: chv_history_cum_periods chcp

2691: into range_inserted
2692: from sys.dual
2693: where exists (select null
2694: from chv_cum_periods ccp,
2695: chv_history_cum_periods chcp
2696: where ccp.cum_period_id = chcp.cum_period_id
2697: and chcp.purge_name = p_purge_name);
2698:
2699: -- 1783982 fbreslin: Compare using :p_catagory rather than p_purge_name

Line 2704: insert into chv_history_cum_periods

2700:
2701: if (p_category = 'SCHEDULES BY CUM PERIODS' AND
2702: NVL(range_inserted,'N') <> 'Y') then
2703: -- summarize_schedules_by_org
2704: insert into chv_history_cum_periods
2705: (cum_period_id,
2706: cum_period_name,
2707: cum_period_start_date,
2708: cum_period_end_date,

Line 7329: delete from chv_history_cum_periods

7325: BEGIN
7326: delete from chv_history_schedules
7327: where purge_name = g_purge_name;
7328:
7329: delete from chv_history_cum_periods
7330: where purge_name = g_purge_name;
7331:
7332: RETURN (TRUE);
7333: