APPS.PAY_PAY_DEL dependencies on PAY_ALL_PAYROLLS_F

Line 72: delete from pay_all_payrolls_f

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

Line 85: delete from pay_all_payrolls_f

81: --
82: -- Delete the row(s) where the effective start date is greater than
83: -- or equal to the validation start date.
84: --
85: delete from pay_all_payrolls_f
86: where payroll_id = p_rec.payroll_id
87: and effective_start_date >= p_validation_start_date;
88: --
89:

Line 274: from pay_all_payrolls_f t1

270: -- Cursor C_Sel1 select comments to be deleted
271: --
272: Cursor C_Sel1 is
273: select t1.comment_id
274: from pay_all_payrolls_f t1
275: where t1.comment_id is not null
276: and t1.payroll_id = p_rec.payroll_id
277: and t1.effective_start_date <= p_validation_end_date
278: and t1.effective_end_date >= p_validation_start_date

Line 281: from pay_all_payrolls_f t2

277: and t1.effective_start_date <= p_validation_end_date
278: and t1.effective_end_date >= p_validation_start_date
279: and not exists
280: (select 1
281: from pay_all_payrolls_f t2
282: where t2.comment_id = t1.comment_id
283: and t2.payroll_id = t1.payroll_id
284: and (t2.effective_start_date > p_validation_end_date
285: or t2.effective_end_date < p_validation_start_date));

Line 543: (p_module_name => 'PAY_ALL_PAYROLLS_F'

539: --
540: when hr_api.cannot_find_prog_unit then
541: --
542: hr_api.cannot_find_prog_unit_error
543: (p_module_name => 'PAY_ALL_PAYROLLS_F'
544: ,p_hook_type => 'AD');
545: --
546: end;
547: --