eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_JRT_BUS dependencies on PER_JOBS

Line 129: from per_jobs a

125: l_exists varchar2(1);
126: --
127: cursor c1 is
128: select null
129: from per_jobs a
130: where a.job_id = p_job_id
131: and a.business_group_id + 0 = p_business_group_id
132: and p_effective_date between a.date_from and
133: nvl(a.date_to, p_effective_date);

Line 160: -- check if job_id value exists in per_jobs table

156: and nvl(p_job_id,hr_api.g_number)
157: <> nvl(ben_jrt_shd.g_old_rec.job_id,hr_api.g_number)
158: or not l_api_updating) then
159: --
160: -- check if job_id value exists in per_jobs table
161: --
162: open c1;
163: --
164: fetch c1 into l_dummy;

Line 169: -- raise error as FK does not relate to PK in per_jobs

165: if c1%notfound then
166: --
167: close c1;
168: --
169: -- raise error as FK does not relate to PK in per_jobs
170: -- table.
171: --
172: ben_jrt_shd.constraint_error('BEN_JOB_RT_FK2');
173: --