APPS.BEN_XER_BUS dependencies on BEN_EXT_RCD

Line 172: from ben_ext_rcd a

168: l_dummy varchar2(1);
169: --
170: cursor c1 is
171: select null
172: from ben_ext_rcd a
173: where a.ext_rcd_id = p_ext_rcd_id;
174: --
175: Begin
176: --

Line 188: -- check if ext_rcd_id value exists in ben_ext_rcd table

184: and nvl(p_ext_rcd_id,hr_api.g_number)
185: <> nvl(ben_xer_shd.g_old_rec.ext_rcd_id,hr_api.g_number)
186: or not l_api_updating) then
187: --
188: -- check if ext_rcd_id value exists in ben_ext_rcd table
189: --
190: open c1;
191: --
192: fetch c1 into l_dummy;

Line 197: -- raise error as FK does not relate to PK in ben_ext_rcd

193: if c1%notfound then
194: --
195: close c1;
196: --
197: -- raise error as FK does not relate to PK in ben_ext_rcd
198: -- table.
199: --
200: ben_xer_shd.constraint_error('BEN_EXT_DATA_ELMT_IN_RCD_FK2');
201: --

Line 884: from ben_ext_rcd

880: l_proc varchar2(72) := g_package||'chk_rcd_type';
881: l_api_updating boolean;
882:
883: cursor c1 is select rcd_type_cd
884: from ben_ext_rcd
885: where ext_rcd_id = p_ext_rcd_id;
886:
887: cursor c2 is select data_elmt_typ_cd, alwd_in_rcd_cd
888: from ben_ext_data_elmt a, ben_ext_fld b

Line 892: typ_cd ben_ext_rcd.rcd_type_cd%type;

888: from ben_ext_data_elmt a, ben_ext_fld b
889: where a.ext_data_elmt_id = p_ext_data_elmt_id
890: and a.ext_fld_id = b.ext_fld_id;
891:
892: typ_cd ben_ext_rcd.rcd_type_cd%type;
893: data_typ_cd ben_ext_data_elmt.data_elmt_typ_cd%type;
894: alwd_cd ben_ext_fld.alwd_in_rcd_cd%type;
895: --
896: Begin