APPS.PAY_ELE_DEL dependencies on PAY_ELEMENT_ENTRIES_F

Line 72: delete from pay_element_entries_f

68: --
69: -- Delete the where the effective start date is equal
70: -- to the validation end date.
71: --
72: delete from pay_element_entries_f
73: where element_entry_id = p_rec.element_entry_id
74: and effective_start_date = p_validation_start_date;
75: --
76: pay_ele_shd.g_api_dml := false; -- Unset the api dml status

Line 83: delete from pay_element_entries_f

79: --
80: -- Delete the row(s) where the effective start date is greater than
81: -- or equal to the validation start date.
82: --
83: delete from pay_element_entries_f
84: where element_entry_id = p_rec.element_entry_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: pay_ele_shd.g_api_dml := false; -- Unset the api dml status

Line 247: from pay_element_entries_f t1

243: -- Cursor C_Sel1 select comments to be deleted
244: --
245: Cursor C_Sel1 is
246: select t1.comment_id
247: from pay_element_entries_f t1
248: where t1.comment_id is not null
249: and t1.element_entry_id = p_rec.element_entry_id
250: and t1.effective_start_date <= p_validation_end_date
251: and t1.effective_end_date >= p_validation_start_date

Line 254: from pay_element_entries_f t2

250: and t1.effective_start_date <= p_validation_end_date
251: and t1.effective_end_date >= p_validation_start_date
252: and not exists
253: (select 1
254: from pay_element_entries_f t2
255: where t2.comment_id = t1.comment_id
256: and t2.element_entry_id = t1.element_entry_id
257: and (t2.effective_start_date > p_validation_end_date
258: or t2.effective_end_date < p_validation_start_date));

Line 472: (p_module_name => 'PAY_ELEMENT_ENTRIES_F'

468: --
469: when hr_api.cannot_find_prog_unit then
470: --
471: hr_api.cannot_find_prog_unit_error
472: (p_module_name => 'PAY_ELEMENT_ENTRIES_F'
473: ,p_hook_type => 'AD');
474: --
475: end;
476: --