APPS.BEN_EPF_BUS dependencies on BEN_PCT_FL_TM_FCTR

Line 122: from ben_pct_fl_tm_fctr a

118: --
119: --
120: cursor c1 is
121: select null
122: from ben_pct_fl_tm_fctr a
123: where a.pct_fl_tm_fctr_id = p_pct_fl_tm_fctr_id
124: and a.business_group_id + 0 = p_business_group_id;
125: --
126: cursor c3 is

Line 151: -- check if pct_fl_tm_fctr_id value exists in ben_pct_fl_tm_fctr table

147: and nvl(p_pct_fl_tm_fctr_id,hr_api.g_number)
148: <> nvl(ben_epf_shd.g_old_rec.pct_fl_tm_fctr_id,hr_api.g_number)
149: or not l_api_updating) then
150: --
151: -- check if pct_fl_tm_fctr_id value exists in ben_pct_fl_tm_fctr table
152: --
153: open c1;
154: --
155: fetch c1 into l_dummy;

Line 160: -- raise error as FK does not relate to PK in ben_pct_fl_tm_fctr

156: if c1%notfound then
157: --
158: close c1;
159: --
160: -- raise error as FK does not relate to PK in ben_pct_fl_tm_fctr
161: -- table.
162: --
163: ben_epf_shd.constraint_error('BEN_ELIG_PCT_FL_FK1');
164: --