APPS.BEN_CCT_DEL dependencies on BEN_CM_TYP_F

Line 71: delete from ben_cm_typ_f

67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --
71: delete from ben_cm_typ_f
72: where cm_typ_id = p_rec.cm_typ_id
73: and effective_start_date = p_validation_start_date;
74: --
75: -- Delete from MLS table.

Line 77: delete from ben_cm_typ_f_tl

73: and effective_start_date = p_validation_start_date;
74: --
75: -- Delete from MLS table.
76: --
77: delete from ben_cm_typ_f_tl
78: where cm_typ_id = p_rec.cm_typ_id
79: and effective_start_date = p_validation_start_date;
80: --
81: ben_cct_shd.g_api_dml := false; -- Unset the api dml status

Line 89: delete from ben_cm_typ_f

85: --
86: -- Delete the row(s) where the effective start date is greater than
87: -- or equal to the validation start date.
88: --
89: delete from ben_cm_typ_f
90: where cm_typ_id = p_rec.cm_typ_id
91: and effective_start_date >= p_validation_start_date;
92: --
93: delete from ben_cm_typ_f_tl

Line 93: delete from ben_cm_typ_f_tl

89: delete from ben_cm_typ_f
90: where cm_typ_id = p_rec.cm_typ_id
91: and effective_start_date >= p_validation_start_date;
92: --
93: delete from ben_cm_typ_f_tl
94: where cm_typ_id = p_rec.cm_typ_id
95: and effective_start_date >= p_validation_start_date;
96: --
97: ben_cct_shd.g_api_dml := false; -- Unset the api dml status

Line 375: (p_module_name => 'ben_cm_typ_f'

371: --
372: when hr_api.cannot_find_prog_unit then
373: --
374: hr_api.cannot_find_prog_unit_error
375: (p_module_name => 'ben_cm_typ_f'
376: ,p_hook_type => 'AD');
377: --
378: end;
379: --