APPS.PAY_OPM_DEL dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 71: delete from pay_org_payment_methods_f

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

Line 82: delete from pay_org_payment_methods_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_org_payment_methods_f
83: where org_payment_method_id = p_rec.org_payment_method_id
84: and effective_start_date >= p_validation_start_date;
85: --
86: pay_opm_shd.g_api_dml := false; -- Unset the api dml status

Line 246: from pay_org_payment_methods_f t1

242: -- Cursor C_Sel1 select comments to be deleted
243: --
244: Cursor C_Sel1 is
245: select distinct t1.comment_id
246: from pay_org_payment_methods_f t1
247: where t1.comment_id is not null
248: and t1.org_payment_method_id = p_rec.org_payment_method_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_org_payment_methods_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_org_payment_methods_f t2
254: where t2.comment_id = t1.comment_id
255: and t2.org_payment_method_id = t1.org_payment_method_id
256: and (t2.effective_start_date > p_validation_end_date
257: or t2.effective_end_date < p_validation_start_date));

Line 470: (p_module_name => 'PAY_ORG_PAYMENT_METHODS_F'

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

Line 565: from pay_org_payment_methods_f opm

561: ) is
562: --
563: cursor csr_bus_grp is
564: select opm.business_group_id
565: from pay_org_payment_methods_f opm
566: where opm.org_payment_method_id = p_org_payment_method_id;
567: --
568: l_rec pay_opm_shd.g_rec_type;
569: l_proc varchar2(72) := g_package||'del';