APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_PA_HISTORY

Line 2191: delete from ghr_pa_history

2187: if l_del_flag = 'Y' then
2188: delete per_people_extra_info
2189: where person_extra_info_id = l_person_extra_info_id;
2190:
2191: delete from ghr_pa_history
2192: where table_name = 'PER_PEOPLE_EXTRA_INFO'
2193: and information1 = l_person_extra_info_id;
2194:
2195: end if;

Line 2198: delete from ghr_pa_history

2194:
2195: end if;
2196:
2197: if l_upd_flag = 'Y' then
2198: delete from ghr_pa_history
2199: where table_name = 'PER_PEOPLE_EXTRA_INFO'
2200: and to_number(information4) = p_person_id
2201: and information5 = 'GHR_US_PER_UPDATE34'
2202: and pa_request_id = l_altered_pa_request_id ;