DBA Data[Home] [Help]

APPS.BEN_ECR_BUS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 110: from ben_elig_per_elctbl_chc a

106: l_dummy varchar2(1);
107: --
108: cursor c1 is
109: select null
110: from ben_elig_per_elctbl_chc a
111: where a.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
112: --
113: Begin
114: --

Line 127: -- ben_elig_per_elctbl_chc table

123: <> nvl(ben_ecr_shd.g_old_rec.elig_per_elctbl_chc_id,hr_api.g_number)
124: or not l_api_updating) and p_elig_per_elctbl_chc_id is not null then
125: --
126: -- check if elig_per_elctbl_chc_id value exists in
127: -- ben_elig_per_elctbl_chc table
128: --
129: open c1;
130: --
131: fetch c1 into l_dummy;

Line 136: -- raise error as FK does not relate to PK in ben_elig_per_elctbl_chc

132: if c1%notfound then
133: --
134: close c1;
135: --
136: -- raise error as FK does not relate to PK in ben_elig_per_elctbl_chc
137: -- table.
138: --
139: ben_ecr_shd.constraint_error('BEN_ENRT_RT_FK2');
140: --