APPS.BEN_XER_SHD dependencies on BEN_EXT_FILE

Line 34: from ben_ext_file xfi,

30: --
31: l_proc varchar2(72) := g_package||'constraint_error';
32: cursor c1 is
33: select xfi.name
34: from ben_ext_file xfi,
35: ben_ext_rcd_in_file xrf,
36: ben_ext_data_elmt_in_rcd xdr
37: where xdr.ext_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
38: and xdr.ext_rcd_id = xdr.ext_rcd_id

Line 44: from ben_ext_file xfi,

40: and xrf.ext_file_id = xfi.ext_file_id;
41:
42: cursor c2 is
43: select xfi.name
44: from ben_ext_file xfi,
45: ben_ext_rcd_in_file xrf,
46: ben_ext_data_elmt_in_rcd xdr
47: where xdr.ext_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
48: and xdr.ext_rcd_id = xdr.ext_rcd_id

Line 54: from ben_ext_file xfi,

50: and xrf.ext_file_id = xfi.ext_file_id;
51:
52: cursor c3 is
53: select xfi.name
54: from ben_ext_file xfi,
55: ben_ext_rcd_in_file xrf,
56: ben_ext_data_elmt_in_rcd xdr
57: where xdr.ext_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
58: and xdr.ext_rcd_id = xdr.ext_rcd_id

Line 64: from ben_ext_file xfi,

60: and xrf.ext_file_id = xfi.ext_file_id;
61:
62: cursor c4 is
63: select xfi.name
64: from ben_ext_file xfi,
65: ben_ext_rcd_in_file xrf,
66: ben_ext_data_elmt_in_rcd xdr
67: where xdr.ext_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
68: and xdr.ext_rcd_id = xdr.ext_rcd_id

Line 74: from ben_ext_file xfi,

70: and xrf.ext_file_id = xfi.ext_file_id;
71:
72: cursor c5 is
73: select xfi.name
74: from ben_ext_file xfi,
75: ben_ext_rcd_in_file xrf,
76: ben_ext_where_clause xwc
77: where xwc.cond_ext_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
78: and xwc.ext_rcd_in_file_id = xrf.ext_rcd_in_file_id

Line 81: l_name ben_ext_file.name%TYPE; -- UTF8 varchar2(100);

77: where xwc.cond_ext_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
78: and xwc.ext_rcd_in_file_id = xrf.ext_rcd_in_file_id
79: and xrf.ext_file_id = xfi.ext_file_id;
80:
81: l_name ben_ext_file.name%TYPE; -- UTF8 varchar2(100);
82: --
83: Begin
84: hr_utility.set_location('Entering:'||l_proc, 5);
85: --