APPS.BEN_XRF_BUS dependencies on BEN_EXT_FILE

Line 295: from ben_ext_file a

291: l_dummy varchar2(1);
292: --
293: cursor c1 is
294: select null
295: from ben_ext_file a
296: where a.ext_file_id = p_ext_file_id;
297: --
298: Begin
299: --

Line 311: -- check if ext_file_id value exists in ben_ext_file table

307: and nvl(p_ext_file_id,hr_api.g_number)
308: <> nvl(ben_xrf_shd.g_old_rec.ext_file_id,hr_api.g_number)
309: or not l_api_updating) then
310: --
311: -- check if ext_file_id value exists in ben_ext_file table
312: --
313: open c1;
314: --
315: fetch c1 into l_dummy;

Line 320: -- raise error as FK does not relate to PK in ben_ext_file

316: if c1%notfound then
317: --
318: close c1;
319: --
320: -- raise error as FK does not relate to PK in ben_ext_file
321: -- table.
322: --
323: ben_xrf_shd.constraint_error('BEN_EXT_RCD_IN_FILE_FK1');
324: --

Line 1020: ben_ext_file b

1016: -- attached to grouping element
1017: cursor c_ext_file_group is
1018: select 'x'
1019: from ben_ext_rcd_in_file a ,
1020: ben_ext_file b
1021: where a.ext_rcd_in_file_id = p_ext_rcd_in_file_id
1022: and a.ext_file_id = b.ext_file_id
1023: and a.ext_rcd_in_file_id = b.ext_rcd_in_file_id ;
1024:

Line 1060: fnd_message.set_token('TABLE_NAME','Ben_Ext_file.Grouping');

1056: fetch c_ext_file_group into l_dummy ;
1057: if c_ext_file_group%found then
1058: close c_ext_file_group ;
1059: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1060: fnd_message.set_token('TABLE_NAME','Ben_Ext_file.Grouping');
1061: fnd_message.raise_error;
1062: end if ;
1063: close c_ext_file_group ;
1064: