APPS.GHR_DUT_DEL dependencies on GHR_DUTY_STATIONS_F

Line 72: delete from ghr_duty_stations_f

68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --
71: hr_utility.set_location('dt_delete_dml NAR IF ',10);
72: delete from ghr_duty_stations_f
73: where duty_station_id = p_rec.duty_station_id
74: and effective_start_date = p_validation_start_date;
75: --
76: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status

Line 85: delete from ghr_duty_stations_f

81: -- Delete the row(s) where the effective start date is greater than
82: -- or equal to the validation start date.
83: --
84: hr_utility.set_location('dt_delete_dml NAR ELSE ',15);
85: delete from ghr_duty_stations_f
86: where duty_station_id = p_rec.duty_station_id
87: and effective_start_date >= p_validation_start_date;
88: --
89: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status