APPS.BEN_PRV_BUS dependencies on BEN_PRTT_ENRT_RSLT_F

Line 113: from ben_prtt_enrt_rslt_f a

109: l_dummy varchar2(1);
110: --
111: cursor c1 is
112: select null
113: from ben_prtt_enrt_rslt_f a
114: where a.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
115: and p_effective_date
116: between a.effective_start_date
117: and a.effective_end_date;

Line 132: -- check if prtt_enrt_rslt_id value exists in ben_prtt_enrt_rslt_f table

128: and nvl(p_prtt_enrt_rslt_id,hr_api.g_number)
129: <> nvl(ben_prv_shd.g_old_rec.prtt_enrt_rslt_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if prtt_enrt_rslt_id value exists in ben_prtt_enrt_rslt_f table
133: --
134: open c1;
135: --
136: fetch c1 into l_dummy;

Line 141: -- raise error as FK does not relate to PK in ben_prtt_enrt_rslt_f

137: if c1%notfound then
138: --
139: close c1;
140: --
141: -- raise error as FK does not relate to PK in ben_prtt_enrt_rslt_f
142: -- table.
143: --
144: ben_prv_shd.constraint_error('BEN_PRTT_RT_VAL_DT1');
145: --

Line 1509: from ben_prtt_enrt_rslt_f pen

1505: l_message_name varchar2(500) := 'BEN_94592_RT_STRT_GT_END_DT';
1506: --
1507: cursor c_person_id is
1508: select person_id
1509: from ben_prtt_enrt_rslt_f pen
1510: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id;
1511: --
1512: Begin
1513: --