DBA Data[Home] [Help]

APPS.BEN_CMT_BUS dependencies on BEN_CM_TYP_F

Line 112: from ben_cm_typ_f a

108: l_dummy varchar2(1);
109: --
110: cursor c1 is
111: select null
112: from ben_cm_typ_f a
113: where a.cm_typ_id = p_cm_typ_id;
114: --
115: Begin
116: --

Line 129: -- check if cm_typ_id value exists in ben_cm_typ_f table

125: <> nvl(ben_cmt_shd.g_old_rec.cm_typ_id,hr_api.g_number)
126: or not l_api_updating) and
127: p_cm_typ_id is not null then
128: --
129: -- check if cm_typ_id value exists in ben_cm_typ_f table
130: --
131: open c1;
132: --
133: fetch c1 into l_dummy;

Line 138: -- raise error as FK does not relate to PK in ben_cm_typ_f

134: if c1%notfound then
135: --
136: close c1;
137: --
138: -- raise error as FK does not relate to PK in ben_cm_typ_f
139: -- table.
140: --
141: ben_cmt_shd.constraint_error('BEN_CM_DLVRY_MTHD_TYP_FK3');
142: --