APPS.BEN_XRF_BUS dependencies on BEN_EXT_RCD_IN_FILE

Line 72: , ben_ext_rcd_in_file xrf

68: --
69: cursor csr_sec_grp is
70: select pbg.security_group_id
71: from per_business_groups pbg
72: , ben_ext_rcd_in_file xrf
73: where xrf.ext_rcd_in_file_id = p_ext_rcd_in_file_id
74: and pbg.business_group_id = xrf.business_group_id;
75: --
76: -- Declare local variables

Line 165: ben_xrf_shd.constraint_error('BEN_EXT_RCD_IN_FILE_PK');

161: <> ben_xrf_shd.g_old_rec.ext_rcd_in_file_id) then
162: --
163: -- raise error as PK has changed
164: --
165: ben_xrf_shd.constraint_error('BEN_EXT_RCD_IN_FILE_PK');
166: --
167: elsif not l_api_updating then
168: --
169: -- check if PK is null

Line 175: ben_xrf_shd.constraint_error('BEN_EXT_RCD_IN_FILE_PK');

171: if p_ext_rcd_in_file_id is not null then
172: --
173: -- raise error as PK is not null
174: --
175: ben_xrf_shd.constraint_error('BEN_EXT_RCD_IN_FILE_PK');
176: --
177: end if;
178: --
179: end if;

Line 248: ben_xrf_shd.constraint_error('BEN_EXT_RCD_IN_FILE_FK2');

244: --
245: -- raise error as FK does not relate to PK in ben_ext_rcd
246: -- table.
247: --
248: ben_xrf_shd.constraint_error('BEN_EXT_RCD_IN_FILE_FK2');
249: --
250: end if;
251: --
252: close c1;

Line 323: ben_xrf_shd.constraint_error('BEN_EXT_RCD_IN_FILE_FK1');

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: --
325: end if;
326: --
327: close c1;

Line 867: from ben_ext_rcd_in_file

863: --
864: l_proc varchar2(72) := g_package||'chk_seq_num_unq';
865: l_dummy char(1);
866: cursor c1 is select null
867: from ben_ext_rcd_in_file
868: Where ext_file_id = p_ext_file_id
869: and ext_rcd_in_file_id <> nvl(p_ext_rcd_in_file_id,-1)
870: and seq_num = p_seq_num
871: and ((business_group_id is null and legislation_code is null)

Line 1019: from ben_ext_rcd_in_file a ,

1015:
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 ;

Line 1300: ben_ext_rcd_in_file b

1296: --
1297: cursor csr_leg_code is
1298: select a.legislation_code
1299: from per_business_groups a,
1300: ben_ext_rcd_in_file b
1301: where b.ext_rcd_in_file_id = p_ext_rcd_in_file_id
1302: and a.business_group_id(+) = b.business_group_id;
1303: --
1304: -- Declare local variables