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_PCD_BUS dependencies on PER_ADDRESSES

Line 116: from per_addresses a

112: l_dummy varchar2(1);
113: --
114: cursor c1 is
115: select null
116: from per_addresses a
117: where a.address_id = p_address_id;
118: --
119: Begin
120: --

Line 134: -- check if address_id value exists in per_addresses table

130: <> nvl(ben_pcd_shd.g_old_rec.address_id,hr_api.g_number)
131: or not l_api_updating) and
132: p_address_id is not null then
133: --
134: -- check if address_id value exists in per_addresses table
135: --
136: open c1;
137: --
138: fetch c1 into l_dummy;

Line 143: -- raise error as FK does not relate to PK in per_addresses

139: if c1%notfound then
140: --
141: close c1;
142: --
143: -- raise error as FK does not relate to PK in per_addresses
144: -- table.
145: --
146: ben_pcd_shd.constraint_error('BEN_PER_CM_PRVDD_F_FK2');
147: --