APPS.PAY_PEL_DEL dependencies on PAY_ELEMENT_LINKS_F

Line 71: delete from pay_element_links_f

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

Line 82: delete from pay_element_links_f

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

Line 246: from pay_element_links_f t1

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

Line 253: from pay_element_links_f t2

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

Line 446: (p_module_name => 'PAY_ELEMENT_LINKS_F'

442: --
443: when hr_api.cannot_find_prog_unit then
444: --
445: hr_api.cannot_find_prog_unit_error
446: (p_module_name => 'PAY_ELEMENT_LINKS_F'
447: ,p_hook_type => 'AD');
448: --
449: end;
450: --