APPS.BEN_ADS_BUS dependencies on BEN_DED_SCHED_PY_FREQ

Line 116: from ben_ded_sched_py_freq a

112: l_dummy varchar2(1);
113: --
114: cursor c1 is
115: select null
116: from ben_ded_sched_py_freq a
117: where a.ded_sched_py_freq_id = p_ded_sched_py_freq_id;
118: --
119: Begin
120: --

Line 133: -- check if ded_sched_py_freq_id value exists in ben_ded_sched_py_freq table

129: and nvl(p_ded_sched_py_freq_id,hr_api.g_number)
130: <> nvl(ben_ads_shd.g_old_rec.ded_sched_py_freq_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if ded_sched_py_freq_id value exists in ben_ded_sched_py_freq table
134: --
135: if p_ded_sched_py_freq_id is not null then
136: open c1;
137: --

Line 143: -- raise error as FK does not relate to PK in ben_ded_sched_py_freq

139: if c1%notfound then
140: --
141: close c1;
142: --
143: -- raise error as FK does not relate to PK in ben_ded_sched_py_freq
144: -- table.
145: --
146: ben_ads_shd.constraint_error('BEN_ACTY_RT_DED_SCHED_FK2');
147: --

Line 354: from ben_ded_sched_py_freq a

350: l_dummy varchar2(1);
351: --
352: cursor c1 is
353: select null
354: from ben_ded_sched_py_freq a
355: where a.acty_rt_ded_sched_id = p_acty_rt_ded_sched_id;
356: --
357: Begin
358: --

Line 361: -- check if child rows exist in ben_ded_sched_py_freq

357: Begin
358: --
359: hr_utility.set_location('Entering:'||l_proc,5);
360: --
361: -- check if child rows exist in ben_ded_sched_py_freq
362: --
363: open c1;
364: --
365: fetch c1 into l_dummy;

Line 372: -- ben_dsq_shd.constraint_error('BEN_DED_SCHED_PY_FREQ_DT1');

368: close c1;
369: -- raise error as child rows exist.
370: --
371: Return(true);
372: -- ben_dsq_shd.constraint_error('BEN_DED_SCHED_PY_FREQ_DT1');
373: --
374: Else
375: --
376: close c1;

Line 566: l_table_name := 'ben_ded_sched_py_freq';

562: --
563: If (chk_dsq_rows_exist
564: (p_acty_rt_ded_sched_id => p_acty_rt_ded_sched_id)) Then
565: --
566: l_table_name := 'ben_ded_sched_py_freq';
567: Raise l_rows_exist;
568: --
569: End if;
570: --