DBA Data[Home] [Help]

APPS.BEN_REG_DEL dependencies on BEN_REGN_F

Line 71: delete from ben_regn_f

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

Line 77: delete from ben_regn_f_tl

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

Line 89: delete from ben_regn_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_regn_f
90: where regn_id = p_rec.regn_id
91: and effective_start_date >= p_validation_start_date;
92: --
93: -- Delete from MLS table.

Line 95: delete from ben_regn_f_tl

91: and effective_start_date >= p_validation_start_date;
92: --
93: -- Delete from MLS table.
94: --
95: delete from ben_regn_f_tl
96: where regn_id = p_rec.regn_id
97: and effective_start_date >= p_validation_start_date;
98: --
99: ben_reg_shd.g_api_dml := false; -- Unset the api dml status

Line 366: (p_module_name => 'ben_regn_f'

362: --
363: when hr_api.cannot_find_prog_unit then
364: --
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'ben_regn_f'
367: ,p_hook_type => 'AD');
368: --
369: end;
370: --